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/A
even 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:
https://docs.google.com/spreadsheets/d/1HQERC4AP2O2j32IQ4VV2us4XPONJTqG0Tl2lOGj402Y/edit?usp=sharing
Archivo > Configuración de la hoja de cálculo
then check theMostrar fórmulas en inglés
checkbox. Also bear in mind that you could post question in Spanish on Stack Overflow en español.