| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking/adding items from like sheets
I want to link info from two tabs (sheets) in excel into another Tab (sheet).
Say I want every time that the word GREEN is in a Row in (Tab 1) and GREEN is in (Tab 2) That GREEN is placed in Tab 3 . Does this make sense. I have two reports with some data that is dublicate (Or I want to find out which items are dublicated in both tabs). How would I do this. I want to capute the results. any help? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linking/adding items from like sheets
Farmer Ted wrote:
I want to link info from two tabs (sheets) in excel into another Tab (sheet). Say I want every time that the word GREEN is in a Row in (Tab 1) and GREEN is in (Tab 2) That GREEN is placed in Tab 3 . Does this make sense. I have two reports with some data that is dublicate (Or I want to find out which items are dublicated in both tabs). How would I do this. I want to capute the results. any help? Assuming your data is in column A of Sheet1 and Sheet2, you could put this formula in a convenient column of Sheet3: =VLOOKUP(Sheet2!A1,Sheet1!A:A,1,false) then fill down as many rows as you have data in Sheet2. Anywhere you do not see #N/A means the value displayed appears somewhere in both Sheet1 and Sheet2. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding like items from different sheets | Excel Worksheet Functions | |||
| Selective linking items between two worksheets | Excel Worksheet Functions | |||
| linking items from drop down list in excel | Excel Worksheet Functions | |||
| Linking Chart items to files | Charts and Charting in Excel | |||
| Linking items GREATER THAN O on another worksheet in the same Work | Excel Discussion (Misc queries) | |||
Linear Mode
