=VLOOKUP(H1,$A$1:$C$10000,2,FALSE)
where H1 is the other Part#
--
HTH
RP
(remove nothere from the email address if mailing direct)
"TARZAN" wrote in message
...
Part # ADP WC Part# ADP WC
A 10 1 A
?
?
B 14 2 C
?
?
C 20 1 D ?
?
D 30 1 E
?
?
E 32 2 F
?
?
How to solve this in the same excel sheet ( the Part# list is huge ) ?
What would be the formula?
--
Thanks
|