| 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!!! |
| 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 | |||
Threaded Mode
