G
Guest
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(A12,'Res
Only'!$B$2:$T$5000,19,FALSE)),"NA",VLOOKUP(A12,'Res
Only'!$B$2:$T$5000,19,FALSE)),VLOOKUP(A4,'Names List'!$A$5:$E$5500,2,FALSE)))
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(A12,'Res
Only'!$B$2:$T$5000,19,FALSE)),"NA",VLOOKUP(A12,'Res
Only'!$B$2:$T$5000,19,FALSE)),VLOOKUP(A4,'Names List'!$A$5:$E$5500,2,FALSE)))