I am using Google Sheets and have a
VLookup set to find the row in a separate sheet (tab) based on a cell and return a link in the fourth column. I am using this formula:
=IF((ISBLANK(C14)); ; VLOOKUP(C14; 'Sheet Names'!$A$2:$D$20; 4))
There are two problems:
- For some of the queries, it finds the row below the one it should return.
- For some of the queries it shows
#N/Aeven though the value is definitely in the column.
I cannot figure out a pattern to why some do not work.
Here is a link to the spreadsheet: