So, this version must works for you. Does it?
=IFERROR(INDEX(Sheet2!B1:B16,MATCH(Sheet1!A1,Sheet2!A1:A16,1)+1),"")
So, this version must works for you. Does it?
=IFERROR(INDEX(Sheet2!B1:B16,MATCH(Sheet1!A1,Sheet2!A1:A16,1)+1),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks