Need Help On Function

Hi,
What you need is a simple VLOOKUP function. But in order to make a VLOOKUP work Excel needs to know where to go look. Generally, that is a table like the one you have shown on Worksheet 2. The other requirement is that the table is sorted by the first column in an ascending order.
One of the methods used by experienced users is to make the table a NAMED RANGE. This allows you to refer to the name of the table in your VLOOKUP formula instead of specifically defining the range like A1:E150. Also, you can make your range dynamic meaning that as it grows your NAMED RANGE grows with it.

So here are my assumptions:
That your "table" occupies Columns A-E

Go to INSERT>NAME>DEFINE and Type MyRange into the "Names in workbook:: (name can have no spaces if you want a space use the _ underscore character.

In Refers to: type the following exactly assuming your table is on Sheet 2
OFFSET('Sheet 2'!$A$2,0,0,COUNTA('Sheet 2'!$A:$E),5)

Click OK

Go to worksheet 1 and in Cell E2 enter the following formula
VLOOKUP(E1,MyRange,3,FALSE)
and the result using your data should be 10.00.

Hope this helps