LinkBack URL
About LinkBacks
If you use this
=IFERROR(INDEX(Sheet2!B1:B16,MATCH(Sheet1!A1,Sheet2!A1:A16,0)+1),"")
You will get no error but also no results since your date in Sheet1!A1, does not exists in Sheet2! Column A
If you use this
=IFERROR(INDEX(Sheet2!B1:B16,MATCH(Sheet1!A1,Sheet2!A1:A16,0)+1),"")
You will get no error but also no results since your date in Sheet1!A1, does not exists in Sheet2! Column A
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks