| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match 2 Columns and Popluate Another
I am in desperate help.
I have a spreadsheet with 2 tabs. Both tabs have item ID's in the first column. The second columns contain different data. I need to match the items in the first column on the first tab to the first column on the second tab, and if they match retrieve the information from the second tab, second column to be placed on the first tab, third column. Thank you. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Match 2 Columns and Popluate Another
One way
Assume data starts in row2 down In Sheet1, Put in C2: =IF(ISNA(MATCH(A2,Sheet2!A:A,0)),"",INDEX(Sheet2!B :B,MATCH(A2,Sheet2!A:A,0))) Copy down as far as required -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Shazam" wrote: I am in desperate help. I have a spreadsheet with 2 tabs. Both tabs have item ID's in the first column. The second columns contain different data. I need to match the items in the first column on the first tab to the first column on the second tab, and if they match retrieve the information from the second tab, second column to be placed on the first tab, third column. Thank you. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Match 2 Columns and Popluate Another
Perhaps a trip to the help index for VLOOKUP would be useful.
-- Don Guillett SalesAid Software "Shazam" wrote in message ... I am in desperate help. I have a spreadsheet with 2 tabs. Both tabs have item ID's in the first column. The second columns contain different data. I need to match the items in the first column on the first tab to the first column on the second tab, and if they match retrieve the information from the second tab, second column to be placed on the first tab, third column. Thank you. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Match 2 Columns and Popluate Another
You are wonderful!! It worked perfectly. Thank you so very much!
Shazam "Max" wrote: One way Assume data starts in row2 down In Sheet1, Put in C2: =IF(ISNA(MATCH(A2,Sheet2!A:A,0)),"",INDEX(Sheet2!B :B,MATCH(A2,Sheet2!A:A,0))) Copy down as far as required -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Shazam" wrote: I am in desperate help. I have a spreadsheet with 2 tabs. Both tabs have item ID's in the first column. The second columns contain different data. I need to match the items in the first column on the first tab to the first column on the second tab, and if they match retrieve the information from the second tab, second column to be placed on the first tab, third column. Thank you. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Match 2 Columns and Popluate Another
Welcome, Shazam.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Shazam" wrote in message ... You are wonderful!! It worked perfectly. Thank you so very much! Shazam |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help with sorting text in columns to match other columns | Excel Discussion (Misc queries) | |||
| match names in 2 different columns | Excel Discussion (Misc queries) | |||
| If columns match | Excel Worksheet Functions | |||
| Match values from two columns | Excel Worksheet Functions | |||
| How do i Match all COLUMNS? | Excel Worksheet Functions | |||
Linear Mode
