combined IF and Vlookups..

[kins]

Morning,
I would like to combine an ‘IF’ statement with a ‘Vlookup’ – could somebody please help?
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
For example –
Say I have an NI number on sheet 1 - J123456 and if this is on sheet 2 in column 1, I want it to bring back “yes”.
<o> </o>
I’ve got a felling that this is going to be simple but wouldn’t mind some help, please.
<o> </o>
Also, what does ‘ISERROR’ mean within a formula?
<o> </o>
Thanks in advance.
<o> </o>
Kins

 

[VoG]

Try like this

=IF(ISNUMBER(MATCH(A1,Sheet2!A:A,0)),"Yes","No")

See the Help for ISERROR.

 

[kins]

thanks VoG. Much appreciated.

Could you please give me an example of how this might work using IF and Vlookups?

 

[VoG]

Using VLOOKUP

=IF(ISNA(VLOOKUP(A1,Sheet2!A:A,1,FALSE)),"No","Yes")

 

[kins]

fantastic.

thank you, as always I appreciate it.


Regards,

Kins.