Vlookup + If statement

[typical]

I am trying to use vlookup to help someone pull data from the backend of a spreadsheet. 90% of my spreadsheet is working. I am getting vlookup to pull the data from the back and complete the basic columns but for the final column its supposed to output a yes/no based on if the column has anything it in or not. If the column has text in it the output should be "yes" if not "no". my current equation is:

=IF(ISERROR(VLOOKUP(A6,'Ad Hoc'!F4:AE1658,26,FALSE)=TRUE),"No","Yes")
I guess one question to double check, for the column to check data from (26 in the equation) is that based off of the column for the table its searching through or the sheet its refering to?

Thanks for any help I appreciate it!

 

[barry houdini]

Try

=IF(VLOOKUP(A6,'Ad Hoc'!F4:AE1658,26,FALSE)="","No","Yes")

 

[typical]

Edit: that might have worked, let me look at it a little longer. Thanks!

 

[barry houdini]

Are the cells actually blank? If so the formula I suggested should work because it's testing for blanks (a blank cell returned by VLOOKUP always shows as a zero). If they are actually zeroes then try changing "" in formula to 0

=IF(VLOOKUP(A6,'Ad Hoc'!F4:AE1658,26,FALSE)=0,"No","Yes")

 

[typical]

The function is working properly. Thanks for the help, you saved me a few hours of tooling around with if statements!