Look up or errorif?

[SilkyBob]

Hi

I have a list of names on tab Y of a spreadsheet which are all 10 characters long and I want Excel to do the following on a different tab (tab X):

Where I enter a matching string of 10 characters in the first column of tab X, populate the adjacent cell to the right with either 'Y' (if the name exists on the column of names on tab Y), or 'N', if it does not). If I can manage this I'd then like to have a kind of 'best match' option with regard to the 10 characters I'm inputting on tab X.

I've tried playing with Look Up and Error If but can't manage it. Can anyone help please? Much appreciated.

Thanks

 

[gaz_chops]

Welcome to the forum.

Try

=IFERROR(IF(VLOOKUP(A2,Sheet8!$A$1:$A$30,1,0),"Y"),"N")

 

[gaz_chops]

Made a mistake, try

=IF(ISTEXT(VLOOKUP(A3,Sheet8!$A$1:$A$30,1,0)),"Y","N")

 

[SilkyBob]

Thanks SO much. The second one worked a charm! I've been trying to do that for ages now - I can use it across lots of the things I do!

 

[gaz_chops]

You're welcome, the 1st one will work on numbers but not text and vice versa.