=IF(ISNA(VLOOKUP($A329,'From Depot'!$A$2:$O$3955,4,FALSE)),
VLOOKUP($A329,'From Depot'!$A$2:$O$3955,4,FALSE),
VLOOKUP($A32,'From Depot'!$A$2:$O$3955,4,FALSE))

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Steved" wrote in message
...
Hello from Steved

We have two people one labels it E2 the other labels it 2 the both are the
same product. Can I write in the below formula for it to use either for
the
formula to identify. Thankyou.

$A329 is E2
$A$2 is 2

=VLOOKUP($A329,'From Depot'!$A$2:$O$3955,4,FALSE)