You're welcome.

Pete

On Aug 21, 2:14 pm, wilson@irco
wrote:
Thanks Pete



"Pete_UK" wrote:
Try this:

=IF(ISNA(VLOOKUP(A1,table,1,0)),"no","yes")

where A1 is the cell with the lookup value, and table is a named range
covering your data.

Hope this helps.

Pete

On Aug 21, 1:10 pm, wilson@irco
wrote:
Please, what is the proper vlookup syntax to get a yes or no answer in a
vlookup formula, instead of a column return? thanks.- Hide quoted text -

- Show quoted text -