I need a formula to insert a specific value based on a specif text

Hi guys,

my book consists of different products which has price according to products, i need a formula so that when i enter a particular product in one cell i must get the price of the product in another cell,

example:

Cell "a" consists of products and cell "b" consists of price
when i enter product in "a", say apple i must get its price on cell "b" as 35

a b
apple 35
orange 45
grape 26
bananna 42
apple 35
strawbeery 67
orange 45

please help me

Hi,

You need to create the lookup table (price master). Then use vlookup formula.

Please check the attached sheet.

Hi,
thank you for you reply.

am just a beginner in excel, can you tell me in detail on how to configure the look up table. An example would really be helpful.
thank you

Hi,

Have you checked the attachment in my earlier post...? It contains the example s/s.