IF Vlookup remove n/a

[CluelessMess21]

I am currently using this formula and want to get rid of #N/A

IF(VLOOKUP(A3,Sheet2!A:B,2,0)=0,"PAYG",IF(VLOOKUP(A3,Sheet2!A:B,2,0)=1,"LOC")

Any help appreciated!

 

[JoeMo]

If you are using Excel 2007 or a later version try:

=IFERROR(IF(VLOOKUP(A3,Sheet2!A:B,2,0)=0,"PAYG",IF(VLOOKUP(A3,Sheet2!A:B,2,0)=1,"LOC")),"")

Otherwise try:

=IF(ISERROR(IF(VLOOKUP(A3,Sheet2!A:B,2,0)=0,"PAYG",IF(VLOOKUP(A4,Sheet2!A:B,2,0)=1,"LOC"))),"",IF(VLOOKUP(A3,Sheet2!A:B,2,0)=0,"PAYG",IF(VLOOKUP(A3,Sheet2!A:B,2,0)=1,"LOC")))

 

[CluelessMess21]

Thanks JoeMo worked great!