Hi
If your Range in Sheet 2 is say, A! to B9.
Put the following formula in A2 on the first sheet:
=VLOOKUP(A1,Sheet2!A1:B9,2)

You will get an #N/A if there is no number in A1 on the first sheet.

HTH Michael

"Beginner" wrote:

Hi

Just need some help as to which function I use. I have a figure in say A1
that I want to match to the same figure in another worksheet in column A &
return what the figure is in column B to show in A2. I've been using the
vlookup and lookup functions but just seem to get back #N/A.

Hope it makes sense, help would be much appreciated.