| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help getting first column data based on criteria?
Hi there- there seem to be quite a few of these posts, but I can't seem to
get it. I have the following: Ref No Object Color 123 Pen Red 345 Pen Green 678 Pencil Red I'm trying to get the "Ref No" data inserted into a cell if both the object and color are what I want (for instance, I want "345" returned if I type in "pen" and "green" when a table is searched). Any thoughts? Many thanks in advance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional format based on data from another column | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
| Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions | |||
Threaded Mode
