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