I would like to seek help regarding the Index-Match formula, I need to get a data from sheet 2 to sheet 1 by matching values from sheet 2's employee ids and date range.
I would like to seek help regarding the Index-Match formula, I need to get a data from sheet 2 to sheet 1 by matching values from sheet 2's employee ids and date range.
My current formula format is =INDEX(value,MATCH(1,(date=datesheet2$B:$B)*(employee id=employeeid sheet2$A:$A),0))
But sadly getting an error result![]()
May be:
=INDEX(value,MATCH(date&employeeid,sheet2!B:B&sheet2!A:A,0))
If it does not work, try to upload an example file.
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks