vlookup, index match not a clue

[kroters]

hi

im looking for a simple formula to return 2 results. example below is what i want it to look like
-a will be a drop down from product sheet
-b to return customer price from product sheet
-c to return wholesale price from product sheet

a b c
shirt £40 £30

all data is set in same format above on a product sheet and i just want to be able to select the product and the 2 columns b and c to show the data

 

[bkanne]

hi

im looking for a simple formula to return 2 results. example below is what i want it to look like
-a will be a drop down from product sheet
-b to return customer price from product sheet
-c to return wholesale price from product sheet

a b c
shirt £40 £30

all data is set in same format above on a product sheet and i just want to be able to select the product and the 2 columns b and c to show the data

Can you please post a sample of your data?