| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding an item in a list & returning a specific value
Is there a function I can use to ....
- Check if Sheet 1 L1 value is listed anywhere in Sheet 2 Col A. If true, then return the corresponding value from Sheet 2 Col B into the corresponding cell in Sheet 1 Col M. Sheet 1: A....K L M 1 Part 1 2 Part 2 3 Part 3 4/16/2009 Sheet 2: A B 1 Part 3 4/16/2009 2 Part 4 3 Part 5 4/17/2009 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding specific text in one cell and returning data from another | Excel Worksheet Functions | |||
| Finding a specific item between two sheets. | Excel Discussion (Misc queries) | |||
| Returning the most duplicated item | Excel Worksheet Functions | |||
| Pivot Table Column Item List only specific String | Excel Discussion (Misc queries) | |||
| finding lowest priced item in a list | Excel Discussion (Misc queries) | |||
Threaded Mode
