If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Match one column to another?
Ok, I am not an Excel person, but as the IT manager I have been asked to
help someone with a spreadsheet. A SQL database is queried. It returns information. This all works fine. However, two columns return a number. I need to match this number with a list of names. The number 1 will always match to the same person, and so on. What I had hoped to do is put the list of names on sheet2 and have sheet1 replace the numerical values in the two colums with the names that match. How can I do this? Thanks, --- Message posted from http://www.ExcelForum.com/ |
#2
|
|||
|
|||
Match one column to another?
Hi
if i'm understanding you correctly, you could use a VLOOKUP statement if you have sheet 2 set up with column A containing the number and column B containing the associated name then on sheet 1 you could put a formula in a column next to the number columns (assume that the numbers you want to replace with the names is in column C) that said =VLOOKUP(C2,Sheet2!$A$2:$B$100,2,false) which means lookup the value in c2, find the number in the range in column A of sheet 2 and return the associated information from the second column (this formula, in the above scenario would go in D2 of sheet1), you could then copy this formula down as far as you need to go. Hope this helps Cheers JulieD "bobfronk " wrote in message ... Ok, I am not an Excel person, but as the IT manager I have been asked to help someone with a spreadsheet. A SQL database is queried. It returns information. This all works fine. However, two columns return a number. I need to match this number with a list of names. The number 1 will always match to the same person, and so on. What I had hoped to do is put the list of names on sheet2 and have sheet1 replace the numerical values in the two colums with the names that match. How can I do this? Thanks, --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
column comparision counting. | Worksheet Functions | 7 | April 19th, 2004 10:27 PM | |
multiple column match | bluesingingcat | Worksheet Functions | 3 | March 10th, 2004 07:36 PM |
Next Column over | Don Guillett | Worksheet Functions | 1 | February 28th, 2004 10:39 PM |
"Matching" column A's values in column B | Chris.F | Worksheet Functions | 0 | January 12th, 2004 02:24 PM |
Need something similar to MATCH or VLOOKUP | Brian Q. Lehmann | Worksheet Functions | 2 | December 8th, 2003 04:14 PM |