Vlookup result blank instead of N/A or 0

[ensburg]

Hi All,

I did this formulas below but they doesn't work.

Could help someone whats wrong with it?

=IFERROR(VLOOKUP(@J:J;'https://xxx.sharepoint.com/sites/teamwork/yyyy/zzzz/[2020.xlsx]05'!$1:$1048576;5;FALSE),"")
Also tried this one:
=IF(LEN(VLOOKUP(@J:J;'https://xxx.sharepoint.com/sites/teamwork/yyyy/zzzz/[2020.xlsx]05'!$1:$1048576;5;FALSE))=0,"",VLOOKUP(@J:J;'https://xxx.sharepoint.com/sites/teamwork/yyyy/zzzz/[2020.xlsx]05'!$1:$1048576;5;FALSE))

It should work but i'm keep getting this message in all formulas.

 

[mole999]

so "=VLOOKUP(What you want to look up, where you want to look for it, the column number in the range containing the value to return, return an Approximate or Exact match – indicated as 1/TRUE, or 0/FALSE). "

what is @J:J

 

[ensburg]

what is @J:J

In column J there that i'm looking for in other spreadsheet. This was added automaticaly by excel when i'm created the formula. (maybe thats needed, because the workbook is file server. I'm just gues as i'm not and expert.)

 

[mole999]

vlookup will only return the first searched for value in a sorted list, try some known values there

your second code i'm not sure of, searching for len zero is foreign to my brain

 

[ensburg]

With @J:J you don't need to specify every single row, that means use the whole column. so you don't have to put J2, J3 etc.
BTW even if i replace the @J:J with J2 its doesnt work.