| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
match 1 column bringing in a value from another column
I tried using vlookup to lookup information in 1 column then go to another
worksheet and bring in the information for another column. Below is the formula I'm using but I either get #N/A or the wrong information. What I have is a list of outstanding payments I'm trying to match the customer number from one sheet and on the custkey sheet I have the customers account number in column A and the person assigned to clear the payment in column 2. What am I doing wrong? Should I be using a different function key? =VLOOKUP(D2,custkey!$A$2:$B$1267,2) Dot |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
match 1 column bringing in a value from another column
try if source is not sorted
=VLOOKUP(D2,custkey!$A$2:$B$1267,2,false) or the same thing =VLOOKUP(D2,custkey!$A$2:$B$1267,2,0) -- Don Guillett Microsoft MVP Excel SalesAid Software "Dot" wrote in message ... I tried using vlookup to lookup information in 1 column then go to another worksheet and bring in the information for another column. Below is the formula I'm using but I either get #N/A or the wrong information. What I have is a list of outstanding payments I'm trying to match the customer number from one sheet and on the custkey sheet I have the customers account number in column A and the person assigned to clear the payment in column 2. What am I doing wrong? Should I be using a different function key? =VLOOKUP(D2,custkey!$A$2:$B$1267,2) Dot |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
match 1 column bringing in a value from another column
Thanks much Don as that worked!
-- Dot "Don Guillett" wrote: try if source is not sorted =VLOOKUP(D2,custkey!$A$2:$B$1267,2,false) or the same thing =VLOOKUP(D2,custkey!$A$2:$B$1267,2,0) -- Don Guillett Microsoft MVP Excel SalesAid Software "Dot" wrote in message ... I tried using vlookup to lookup information in 1 column then go to another worksheet and bring in the information for another column. Below is the formula I'm using but I either get #N/A or the wrong information. What I have is a list of outstanding payments I'm trying to match the customer number from one sheet and on the custkey sheet I have the customers account number in column A and the person assigned to clear the payment in column 2. What am I doing wrong? Should I be using a different function key? =VLOOKUP(D2,custkey!$A$2:$B$1267,2) Dot |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting data in one column and match with data in another column | Excel Discussion (Misc queries) | |||
| Display missing Part Number if Column A does not match column B | Excel Worksheet Functions | |||
| Sum of column C where results in column A match | Excel Worksheet Functions | |||
| Any way for 2 column vlookups. i.e match last name then match firs | Excel Worksheet Functions | |||
| Need rows in Column A removed if they fully or partially match with any Column B row | Excel Discussion (Misc queries) | |||
Linear Mode
