VLOOKUP or another???

P

PeggyG

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!!!
 
T

Toppers

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?
 
P

PeggyG

Columns are populated. (Sorry!)
Just formatting...I didn't nudge it over.

Thx, again!
 
P

PeggyG

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...
 
T

Toppers

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)
 
P

PeggyG

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???
 
T

Toppers

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
 
P

PeggyG

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!!!
 
Top