VLookup or Index Match ?

T

TARZAN

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?
 
B

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

lookup two different variables 0
trouble with (complicated) vlookup searching another workbook 2
vlookup or index/match formula?? 2
Index/Match Functions to Return Concatenated Response 4
INDEX MATCH SMALL 13
Returning Sorted Values 3
Finding dynamic maxima 9
Function help 7

Top