VLOOKUP or another???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I did post this before and realize I may not have given enough info...

Sheet 1
PO# Date Total Tax ShipTo
20065 1/06 100 10 IMT
20066
20041
20048

Sheet 2
Date PO# SalesPerson Total Tax
1/06 20041 Bob (populate these two from Sheet1)
20065
20066

I have two sheets. Not in the same order (column not row.) Can I populate
the Total and Tx columns from Sheet1 with a look up???

I have tried VLOOKUP, but the ONLY row that works is the first.

Thanks in advance!!!
 
Are the columns for Date,Total etc for PO#s 20066 , 20041 onwards blank?

And are there really PO# in the date column on sheet2 (or is this just the
formatting of the newsgroup?)

And what do we match on ....Date? PO#? Both?
 
AND...want to match on PO#

Toppers said:
Are the columns for Date,Total etc for PO#s 20066 , 20041 onwards blank?

And are there really PO# in the date column on sheet2 (or is this just the
formatting of the newsgroup?)

And what do we match on ....Date? PO#? Both?
Click to expand...
 
I think Nikki's formulae should be (as PO# is in column B on Sheet2):

Total=vlookup($b2,sheet1!$b:$e,3,false)
Tax=vlookup($b2,sheet1!$a:$e,4,false)
 
Thank you - I did change that...here in lies my problem...just to make sure I
wasn't going crazy I created two clean (new) sheets and used the formula.
Worked. Then I took it and applied it to mine and nothing. I'm getting back
#N/A on anything after the first row.

Where do I trouble shoot from???
 
Is it possible that the data formats are "mixed" i.e. the PO# is text in your
spreadsheet and a number in the VLOOKUP (or vice versa)?

Or text in one speadsheet and number in the other?

This is a common cause of #NA errors.

If you ccan't resolve it, send sample to me (toppers at
nospam(remove)johntopley.fsnet.co.uk

HTH
 
Thank you thank you thank you!

I will not reveal the "user error" that was preventing the right results,
but just know it was humorous!

I really appreciate your 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

vlookup instructions,, or help making a formula 7
If isna match function??? 2
vlookup / if ? 4
vlookup with if statement together 6
Copy values from a cell based on values of another cell 4
Excel VBA to move cells to sheet2 based on selection in sheet1 0
VLookup, Dynamic Range or Something else 8
SUMIF or SUMPRODUCT or ?? 2

Back
Top