| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Matching 2 colums from 2 seperate tabs
I am trying to set up a sheet that shows all racking on site and if it is damaged for whatever reason.
I have a sheet with all the locations in it (sheet 1) and if the location appears on the input sheet (sheet 2) then I want the reason why to appear in (sheet 1). This reason is from another column. This will then give me a summary for the warehouse rather than sifting through all the repaired and not repaired damages. Is this possible? |
|
#2
|
|||
|
|||
|
Quote:
If I understand correctly what you mean then yes it's possible. If you email me the spreadsheet you have so far I will show you how. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Matching 2 colums from 2 seperate tabs
I am trying to set up a sheet that shows all racking on site and if it
is damaged for whatever reason. I have a sheet with all the locations in it (sheet 1) and if the location appears on the input sheet (sheet 2) then I want the reason why to appear in (sheet 1). This reason is from another column. This sounds like a straightforward application of VLOOKUP(). A description of the VLOOKUP function is in Excel's built-in Help. On the other hand, it's more complicated if a location can appear more than once in sheet 2. If that's possible, what's the desired result? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Matching two different colums, VLOOKUP? | Excel Discussion (Misc queries) | |||
| Matching Colums & Rows in Different Spreadsheets | Excel Programming | |||
| How do i seperate colums when special pasting information | Excel Programming | |||
| copy row when matching colums found | Excel Programming | |||
| Pasting values from 2 colums into 1 on a seperate workbook? | Excel Worksheet Functions | |||
Linear Mode
