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?