use of vlookup

[Guest]

I have an account number in Col A and want a number from another worksheet
(Col H) from that same account number (whcih appears in Col A of the second
worksheet also).

My formula in the first worksheet in Cell D4 (where I want the answer) is
vlookup(A4, range of data in second worksheet, 8.false). I get a totally
wrong response.

Help.

 

[Guest]

=VLOOKUP(A4,'Sheet2'!A$4:H$1000,8,FALSE)
If this doesn't work then, I am not sure...