ExcelBanter - VLookup or Index Match ?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - VLookup or Index Match ? (https://www.excelbanter.com/excel-worksheet-functions/17793-vlookup-index-match.html)

TARZAN

VLookup or Index Match ?

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

Bob Phillips

=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

All times are GMT +1. The time now is 05:43 AM.