Need help with a Formula

[FootBallBat]

Inside	5	Toolshed	Data	12
Outside	44	Garage	Data	9
Garage	9	Parking	Data	52
		Outside	Data	44
		Inside	Data	5

<tbody>
</tbody>

Im trying to make a formula that when my data (columns c-e) are pasted then I need B1 to match A1 to column "c" and insert the corresponding number from column "e".
Thank you

 

[FootBallBat]

This formula will be in B1

 

[alansidman]

I would suggest you try using the vlookup function in column B

Look here for tutorial MS Excel: VLOOKUP Function (WS)

 

[FootBallBat]

I would suggest you try using the vlookup function in column B

Look here for tutorial MS Excel: VLOOKUP Function (WS)

Thank you soo much