use of vlookup

G

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extremely slow calculation of formulas 4
Combining IF Statement and Vlookup 0
VLOOKUP Help 3
VLookup using VB 5
vlookup returns the formula I entered, not the expected value 1
if function (if more that 7 nesting) 2
Excel Excel Vlookup formula based on cell data 7
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0

Top