how do i vlookup left?

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

 

[Gary''s Student]

Use Match() and Index()
or
Use Match() and Offset()

 

[T. Valko]

Try this:

Lookup order number for HeatB

E1 = HeatB

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

 

[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)

 

[Dave Peterson]

Debra Dalgleish has some nice instructions:
http://contextures.com/xlFunctions03.html

 

[T. Valko]

Just expand the range references or reference the whole columns:

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

 

[Joe@Phoenix]

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

Thank you
-Joe