Excel 2007 : How to match text and insert corresponding data?

Attached is a demo excel sheet. Basically I have a list of part numbers (in this case apple and oranges) in a table. I then want to paste in 2 columns. One with the part numbers and one with the number of parts.

I need to find a way to first match the items in column E to column A. If there is a match the number in column F needs to go in column B. If there is no Match it needs to be "0".

in the example column B should be 9 for apple, 2 for orange and 0 for kiwi.

Any help appreciated!

Why 0 for Kiwi ?

Also you have mix of trailing spaces in the descriptions which will cause the example to fail, I'm presuming these are typos... (ie Apple[space] in A1, Orange[space] in E1 etc...)

Assuming all are typos (are corrected) and results should be 9,2,4 for Apple, Orange, Kiwi respectively then

B1: =VLOOKUP(A1,E:F,2,0)
copied down

(if you have real issues with leading / trailing spaces you will need to provide a more detailed example I think)

my point was more the fact that in your sample you did have quantity for Kiwi... to handle the possibility of no match then either:

a) =IF(ISNA(MATCH(A1,E:E,0)),0,VLOOKUP(A1,E:F,2,0))

or

b) =LOOKUP(9.99999999999999E+307,CHOOSE({1,2},0,VLOOKUP(A1,E:F,2,0)))