Quick question!

[excel_2009]

Hi excel gurus,

Quick question, i was just wondering how i can ignore #N/A when using this vlookup:

=VLOOKUP(F647,Sheet1!A:B,2,0)

thank you

 

[anglais428]

maybe,

=IF(ISNA(VLOOKUP(F647,Sheet1!A:B,2)),0,VLOOKUP(F647,Sheet1!A:B,2,2))

 

[rallcorn]

=if(iserror(VLOOKUP(F647,Sheet1!A:B,2,0)),"",VLOOKUP(F647,Sheet1!A:B,2,0))

 

[excel_2009]

Thank you gurus

 

[Armando Montes]

Another one:
=VLOOKUP(F647,Sheet1!A:B,2,0)&""