Hi all,
I'm trying to use and index match formula to match two different cells and return the 3rd but it keeps coming up with the #N/a and I can't seem to figure out the error.
This is the formula:
{=INDEX(Sheet1!E1:E290,MATCH(1,(FINAL!C3=Sheet1!A1:A290)&(FINAL!B4=Sheet1!B1:B290),0))}
I've checked using F9 that each part is looking up the right information and it looks like it is but it just doesn't want to work
Please help!
Bookmarks