use of vlookup

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
=VLOOKUP(A4,'Sheet2'!A$4:H$1000,8,FALSE)
If this doesn't work then, I am not sure...
 
You must log in or register to reply here.

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
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Combining IF Statement and Vlookup 0
VLookup using VB 5
VLOOKUP Help 3
vlookup returns the formula I entered, not the expected value 1
if function (if more that 7 nesting) 2
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0

Back
Top