Sorry should be =IF(B2="Price",INDEX($F$2:$F$4,MATCH(A2,$E$2:$E$4, 0)),"")


"ck" wrote:

From what i understand is that you want column C to return the price of the
item if column A is selected and column B, you select 'price' from the drop
down list. If so, assuming in your database, you have set column E for all
the items and column F for all the prices for those items, in column C, try
this formula:

=IF(B2="Price",INDEX($F$2:$F$4,MATCH(D2,$E$2:$E$4, 0)),"")

Change the range as accordingly.

Click yes below if this is what you want.


"max007" wrote:

Im am creating a Price Inquiry tool... I am just having problems when it
comes to the lookup for the prices...

I have A1 as the Item Category drop down and B1 as the Item drop down... I
want C3 to return the price of the item once B1 already has the exact item to
lookup...

I created the A1 and B1 as dependent drop down list.

A B C
1 Gardening Water Hose Price


Need help.. Please advise