| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match value return a text
i need a formula in Sheet 2 of Column B to return the appropriate match
category based on value in sheet 2 column A Sheet 1 Column A a b c d e etc Sheet 2 Column A 1 1 1 2 3 4 5 i need to create column B in sheet 2 which look like the example below column A Column B 1 a 1 a 1 a 2 b 3 c 4 e 5 6 d Thanks very much for taking a look and help. ppp |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match Text return a value from the row | Excel Worksheet Functions | |||
| Two colums match return text from another | Excel Discussion (Misc queries) | |||
| MATCH Multiple Criteria & Return Previous / Penultimate Match | Excel Worksheet Functions | |||
| Compare Value in Cell 1 to a List, Return Value if Match otherwise Return Null | Excel Discussion (Misc queries) | |||
| Match text to another worksheet and return a certain value | Excel Worksheet Functions | |||
Threaded Mode
