Help with looking up item price

[Jazntails]

hi all,
i have one sheet with items & set pricing.
-------------------------
A B C D E
items itemcode price1 price2 price 3 etc...
prod1 PR1 29.99 27.95
prod2 PR2 35.99 31.99
prod3 PR3 29.99
etc
-------------------------

price1 in normal price, price2 is a special price & price3 members price. You can see that prod3 is only normal price but prod1 &2 have a special price.

my problem is im trying to lookup on another sheet looking the correct price for the item.
i have been using vlookup, & index & match

any ideas??
Cheers Jas

 

[Aladin Akyurek]

hi all,
i have one sheet with items & set pricing.
-------------------------
A B C D E
items itemcode price1 price2 price 3 etc...
prod1 PR1 29.99 27.95
prod2 PR2 35.99 31.99
prod3 PR3 29.99
etc
-------------------------

price1 in normal price, price2 is a special price & price3 members price. You can see that prod3 is only normal price but prod1 &2 have a special price.

my problem is im trying to lookup on another sheet looking the correct price for the item.
i have been using vlookup, & index & match

any ideas??
Cheers Jas

What is the correct price for a product?

A formula like:

=VLOOKUP(H2,$A$2:$E$100,MATCH(I2,$C$1:$E$1,0),0)

would fetch the price type specified in I2 (a value like price2) for a product specified in H2 (a product like prod2).