Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup Question
I am sure this has been answered before...but I have one sheet of data that
has a number in column A, then a second sheet that has 2 columns, one with a number that will match some of the numbers on Sheet 1 in Column A and have a corresponding number in Column B. I want to match the information from Sheets 1 and Sheets 2 Column As and enter on Sheet 1 the information in Column B from Sheet 2 Example: Sheet 1: 123-1234 Sheet 2: Column A Column B 59871 5 123-1234 8 Thanks for your help! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup Question
In article ,
Shood wrote: I am sure this has been answered before...but I have one sheet of data that has a number in column A, then a second sheet that has 2 columns, one with a number that will match some of the numbers on Sheet 1 in Column A and have a corresponding number in Column B. I want to match the information from Sheets 1 and Sheets 2 Column As and enter on Sheet 1 the information in Column B from Sheet 2 Example: Sheet 1: 123-1234 Sheet 2: Column A Column B 59871 5 123-1234 8 Thanks for your help! Assuming that A2:B100 on Sheet2 contains the source data/table, and A2 on Sheet1 contains the lookup value, try... =VLOOKUP(Sheet1!A2,Sheet2!$A$2:$B$100,2,0) -- Domenic http://www.xl-central.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Another Lookup Question | Excel Discussion (Misc queries) | |||
LOOKUP Question [again!] | Excel Discussion (Misc queries) | |||
LOOKUP Question | Excel Discussion (Misc queries) | |||
Lookup question | Excel Discussion (Misc queries) | |||
Lookup question | Excel Discussion (Misc queries) |