| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Refewrence tables
I have a set of values in column A, and 4 reference columns C, D, and E. I
want to reference column A to find a matching value in either column C,D or E and return a value of the column the match was found in. For example in column A row 2 the value is "jackson" I want excell to look in column C, D and E and if "jackson" is found in column D, then return the value D. The formula will be located in column B. Is this possible? I am stumped. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| concatenate tables into html tables | Excel Discussion (Misc queries) | |||
| concatenate tables into html tables | New Users to Excel | |||
| Antil Log Tables from Log Tables | New Users to Excel | |||
| Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
| Look up tables | Excel Discussion (Misc queries) | |||
Threaded Mode
