Don't know if I'm understanding you but;
=VLOOKUP(product,A20:B25,2,FALSE)
I renamed cell A1 to "product" then A20;A25 as "cheese" etc and B20:B25 as the prices.
The above formula sits in cell A2 and displays the price found in B20:B25
Is this what you're looking for?
Cheers
Tony
Bookmarks