how do i vlookup left?
 

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?

how do i vlookup left?
 

Use Match() and Index()
or
Use Match() and Offset()
--
Gary''s Student - gsnu200902


"Joe@Phoenix" wrote:

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?

how do i vlookup left?
 

Try this:

Lookup order number for HeatB

E1 = HeatB

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

--
Biff
Microsoft Excel MVP


"Joe@Phoenix" wrote in message
...
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?

how do i vlookup left?
 

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. Valko" wrote:

Try this:

Lookup order number for HeatB

E1 = HeatB

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

--
Biff
Microsoft Excel MVP


"Joe@Phoenix" wrote in message
...
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?

how do i vlookup left?
 

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

Joe@Phoenix wrote:

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?

--

Dave Peterson

how do i vlookup left?
 

Just expand the range references or reference the whole columns:

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

--
Biff
Microsoft Excel MVP


"Joe@Phoenix" wrote in message
...
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. Valko" wrote:

Try this:

Lookup order number for HeatB

E1 = HeatB

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

--
Biff
Microsoft Excel MVP


"Joe@Phoenix" wrote in message
...
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?

how do i vlookup left?
 

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

Thank you
-Joe

"Dave Peterson" wrote:

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

Joe@Phoenix wrote:

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?

--

Dave Peterson