| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP or another???
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!!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLOOKUP or another???
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? "PeggyG" wrote: 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!!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLOOKUP or another???
Columns are populated. (Sorry!)
Just formatting...I didn't nudge it over. Thx, again! "Toppers" wrote: 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? "PeggyG" wrote: 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!!! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLOOKUP or another???
AND...want to match on PO#
"Toppers" wrote: 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? "PeggyG" wrote: 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!!! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLOOKUP or another???
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) "Toppers" wrote: 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? "PeggyG" wrote: 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!!! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLOOKUP or another???
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??? "Toppers" wrote: 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) "Toppers" wrote: 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? "PeggyG" wrote: 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!!! |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLOOKUP or another???
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 "PeggyG" wrote: 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??? "Toppers" wrote: 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) "Toppers" wrote: 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? "PeggyG" wrote: 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!!! |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLOOKUP or another???
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!!! "Toppers" wrote: 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 "PeggyG" wrote: 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??? "Toppers" wrote: 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) "Toppers" wrote: 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? "PeggyG" wrote: 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!!! |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLOOKUP or another???
Total=vlookup($a2,sheet1!$a:$e,3,false)
Tax=vlookup($a2,sheet1!$a:$e,4,false) "PeggyG" wrote: 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!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
| IF(a1="x",(vlookup 18K rows,2,false),(vlookup 18K,3,false)) RAM? | Excel Worksheet Functions | |||
| IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Hybrid Mode
