Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Align Data
I've got two columns of unique ID's. I need to match these unique IDs in the
same rows including another column with the data that I need in that column. Basically I've got a spreadsheet with rows of contacts and another spreadsheet with the email addresses for these contacts; however, the rows don't automatically line up. Both tables have this unique ID, but need to match them in order to put the email address in the correct contact row. Any ideas? TIA! -- Krista |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Align Data
Look at VLOOKUP:
On first sheet in B2: =VLOOKUP(A2,Sheet2!$A:$B,2,0) Where A2 = ID Sheet2 columns A & B contain ID and Address The 2 indicates return data from second column in range i.e column B Copy down as required HTH "Krista" wrote: I've got two columns of unique ID's. I need to match these unique IDs in the same rows including another column with the data that I need in that column. Basically I've got a spreadsheet with rows of contacts and another spreadsheet with the email addresses for these contacts; however, the rows don't automatically line up. Both tables have this unique ID, but need to match them in order to put the email address in the correct contact row. Any ideas? TIA! -- Krista |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Align Data
THANKS MUCH -- worked great!
-- Krista "Toppers" wrote: Look at VLOOKUP: On first sheet in B2: =VLOOKUP(A2,Sheet2!$A:$B,2,0) Where A2 = ID Sheet2 columns A & B contain ID and Address The 2 indicates return data from second column in range i.e column B Copy down as required HTH "Krista" wrote: I've got two columns of unique ID's. I need to match these unique IDs in the same rows including another column with the data that I need in that column. Basically I've got a spreadsheet with rows of contacts and another spreadsheet with the email addresses for these contacts; however, the rows don't automatically line up. Both tables have this unique ID, but need to match them in order to put the email address in the correct contact row. Any ideas? TIA! -- Krista |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using offset to align data? | Excel Discussion (Misc queries) | |||
how do i align rows of data | Excel Discussion (Misc queries) | |||
Left align '$' and right align numbers? | Excel Discussion (Misc queries) | |||
Filtering Columns to Align Matching Data | Excel Worksheet Functions | |||
What is short-Cut forleft align and Right align? | Excel Discussion (Misc queries) |