this formula is returning a value ont he "RES ONLY" sheet even if its a
number that dosn't exist, im trying to have it look it up on one sheet, if
its not there, look it up on the

=IF(A4=""," ",IF(ISERROR(VLOOKUP(A4,'Names
List'!$A$5:$E$5500,2,FALSE)),IF(ISERROR(VLOOKUP(A1 2,'Res
Only'!$B$2:$T$5000,19,FALSE)),"NA",VLOOKUP(A12,'Re s
Only'!$B$2:$T$5000,19,FALSE)),VLOOKUP(A4,'Names List'!$A$5:$E$5500,2,FALSE)))

I didnt finish my question for some reason..

I want it took it up on one sheet, if its not there, look it up on the
other, and if its not there then put an " NA" instead of a #N/A

"Michael A" wrote:


this formula is returning a value ont he "RES ONLY" sheet even if its a
number that dosn't exist, im trying to have it look it up on one sheet, if
its not there, look it up on the

=IF(A4=""," ",IF(ISERROR(VLOOKUP(A4,'Names
List'!$A$5:$E$5500,2,FALSE)),IF(ISERROR(VLOOKUP(A1 2,'Res
Only'!$B$2:$T$5000,19,FALSE)),"NA",VLOOKUP(A12,'Re s
Only'!$B$2:$T$5000,19,FALSE)),VLOOKUP(A4,'Names List'!$A$5:$E$5500,2,FALSE)))

ok, i figured it out.. nevermind.. i had the wrong reference

"Michael A" wrote:


this formula is returning a value ont he "RES ONLY" sheet even if its a
number that dosn't exist, im trying to have it look it up on one sheet, if
its not there, look it up on the

=IF(A4=""," ",IF(ISERROR(VLOOKUP(A4,'Names
List'!$A$5:$E$5500,2,FALSE)),IF(ISERROR(VLOOKUP(A1 2,'Res
Only'!$B$2:$T$5000,19,FALSE)),"NA",VLOOKUP(A12,'Re s
Only'!$B$2:$T$5000,19,FALSE)),VLOOKUP(A4,'Names List'!$A$5:$E$5500,2,FALSE)))