Not sure if match, lookup, etc.

[theiguy]

I'm not sure how to phrase this for a proper search (the past few haven't worked). I have a situation similar to this one:

EXAMPLE for mrexcel.xls
	A	B	C	D	E	F	G	H
1	Fruit	p1	p2	p3		Fruit	$	P#?
2	Apples	$0.69	$1.69	$2.69		Apples	0.69
3	Bananas	$0.34	$1.34	$2.34		Bananas	1.34
4	Lemons	$0.55	$1.55	$2.55		Lemons	2.55
5	Oranges	$0.25	$1.25	$2.25		Oranges	2.25
6	Pears	$0.59	$1.59	$2.59		Pears	2.59
7	Almonds	$2.80	$3.80	$4.80		Almonds	3.55
8	Cashews	$3.55	$4.55	$5.55		Cashews	4.55
9	Peanuts	$1.25	$2.25	$3.25		Peanuts	1.25
10	Walnuts	$1.75	$2.75	$3.75		Walnuts	1.75
Sheet2

In COLUMN H, I am trying to determine the P Level (P1, P2, or P3). I'm not very familiar with MATCH, LOOKUP or INDEX but using the MS Help I wasn't able to get very far.

Can anyone point me in the right direction?

Thanks

 

[Jonmo1]

If columns A and F are always EXACT Duplicates of each other...

In H2 put

=INDEX($B$1:$D$1,1,MATCH($G2,$B2:$D2,0))

 

[theiguy]

AWESOME! Thank you very much!