Hi,
I'm trying to return a value on Sheet2 (ID) based on two values in Sheet1 (Provider, Visit) but I'm getting #REF! errors in a majority of the cells. I attached the sheet. Any help would be appreciated.
Hi,
I'm trying to return a value on Sheet2 (ID) based on two values in Sheet1 (Provider, Visit) but I'm getting #REF! errors in a majority of the cells. I attached the sheet. Any help would be appreciated.
In the syntax you are using the second MATCH is returning a value > 1 but the INDEX range has only 1 column, hence #REF! You need to do it slightly differently - try this formula in row 2
=INDEX(Sheet2!$A$2:$A$16,MATCH(1,(Sheet1!B2=Sheet2!$B$2:$B$16)*(Sheet1!D2=Sheet2!$C$2:$C$16),0))
confirmed with CTRL+SHIFT+ENTER and copied down column
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks