Vlookup problem

[Galena1]

Simple vlookup is returning '#NAME?'

=IF(ISNA(VLOOKUP(F6,SoWs!A:A,1,FALSE)),"Yes","No")

What gives?...

Thanks!

 

[MrKowz]

Is SoWs a worksheet in your workbook?

Also, try using a MATCH instead of VLOOKUP for this. It will be much faster:

=IF(ISNA(MATCH(F6,SoWs!A:A,0)),"Yes","No")

 

[schielrn]

Simple vlookup is returning '#NAME?'

=IF(ISNA(VLOOKUP(F6,SoWs!A:A,1,FALSE)),"Yes","No")

What gives?...

Thanks!

I don't see anything as to why that would return a '#NAME?' error, unless somehow a reference is missing?

Maybe go into vba (Alt+F11) and go to tools-->reference and make sure nothing is checked that says missing?

Does this work?

=IF(ISNA(MATCH(F6,SoWs!A:A,0)),"Yes","No")

Hope that helps.

 

[Galena1]

Yeah, that worked using the 'Match' function in the formula.
Although I still don't understand why the original IF Vookup didn't work. I could've swore it has in the past. Oh, well

Thanks everyone for the help!

 

[Trouttrap2]

Could the error be coming from the VLOOKUP? I am thinking that since your table array in the VLOOKUP is one column wide and the column index num you have as "1" is attempting to return the same. Doesn't a Vlookup require a table array and column index num of at least 2 wide?

 

[schielrn]

Could the error be coming from the VLOOKUP? I am thinking that since your table array in the VLOOKUP is one column wide and the column index num you have as "1" is attempting to return the same. Doesn't a Vlookup require a table array and column index num of at least 2 wide?

No you can set it up the way he had it and I have seen plenty of people do it that way to test the same way as you would with the match function. I'm thinking it might have been the false that was the issue, does this not work either?

=IF(ISNA(VLOOKUP(F6,SoWs!A:A,1,0)),"Yes","No")

or this?

=IF(ISNA(MATCH(F6,SoWs!A:A,FALSE)),"Yes","No")

Hope that helps.