how do i vlookup left?

J

Joe@Phoenix

my ex:

Order #1 | Part Number1.1.1 | HeatC
Order #2 | Part Number2.2.2 | HeatB
Order #3 | Part Number3.3.3 | HeatA

sometimes i vlookup the order # to find the heat.
but other times i want to vlookup the heat to find the order number

how can i do this?
 
T

T. Valko

Try this:

Lookup order number for HeatB

E1 = HeatB

=INDEX(A1:A3,MATCH(E1,C1:C3,0))
 
J

Joe@Phoenix

im not real good with using functions im not familiar with. can this be used
with an excel sheet that is constantly being updated? we constantly add new
rows and i am trying to setup a 'checker' for someone to be able to punch in
Heat and it to automatically populate the order number. i have a 'checker'
for someone to punch in the order# and the heat to populate cause that can
work with us always adding rows.

Ex:
Enter Order # | (They enter order number here)
Heat = | =vlookup(order#,A:C,3,false)
 
T

T. Valko

Just expand the range references or reference the whole columns:

=INDEX(A:A,MATCH(E1,C:C,0))
 
J

Joe@Phoenix

thank you all who helped. i ended up using the index & match and it works
great.

Thank you
-Joe
 
Top