=IF(ISERROR(OR(VLOOKUP([vlookup1]),VLOOKUP([vlookup2])),"",IF(ISERROR(VLOOKUP([vlookup1]),VLOOKUP([vlookup2]),VLOOKUP([vlookup1])))

Dave
--
Brevity is the soul of wit.


"Wanna Learn" wrote:

Hello
THis is my formula
=IF(ISNA(IF(ISNA(VLOOKUP($D2,'ALL JDE HARMONIZATION
CODES'!$A$1:$D$27061,4,FALSE)),VLOOKUP(D42,'ALL JDE HARMONIZATION
CODES'!$B$1:$D$27061,3,FALSE))),"",IF(ISNA(VLOOKUP ($D2,'ALL JDE HARMONIZATION
CODES'!$A$1:$D$27061,4,FALSE)),VLOOKUP($D2,'ALL JDE HARMONIZATION
CODES'!$B$1:$D$27061,3,FALSE),VLOOKUP($D2,'ALL JDE HARMONIZATION
CODES'!$A$1:$D$27061,4,FALSE)))

This gives me the right answer but when there is no answer I get 3 different
results I get 0 or blank , (which is what I want) or #NA. Why three
different answers. What is wrong ? thanks