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