Try VLOOKUP:

in A2 on Sheet1

=VLOOKUP(A1,Sheet2!A1:B4,2,0)

HTH

"Kaylean" wrote:

I need the cell A2 on sheet 1 to return a value found in a table I have made
on sheet 2 using LOOKUP. The LOOKUP wizard does not really work in this
instance. I have titled the column labels Number and Price. There are only 2
columns & 4 rows to the table (including the Column Labels). I want to enter
the frequency of attendance in cell A1 on sheet 1 and have the result price
from the table appear in cell A2 sheet 1.
Can anyone help with this request. Urgent many thanks.