| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find A Match Formula
Here's my data table - Starts in A1 (Sheet1)
Type Code 9P170.00 RI 9P170.00 RI 9P160.00 RI 9P160.00 RI 9P150.00 SI 9P150.00 SI 9P140.00 RI 9P140.00 RI I am trying to create this table - Starts in A1 (Sheet2) Type Code 9P170.00 RI 9P160.00 RI 9P150.00 SI 9P140.00 RI So. I am trying to find a formula for B2:B5 that will look at A2:A5 (Sheet2) find the match in A2:A8 (Sheet 1) and if a match is found, return value in B2:B8 (Sheet1). If no match is found, return "No Match". Thank you in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match, Find? | Excel Worksheet Functions | |||
| Using MATCH to find the 2nd match, not only 1st | Excel Discussion (Misc queries) | |||
| How do I display more than one match in a Index/Match formula? | Excel Worksheet Functions | |||
| Lookup Formula - but have a formula if it can't find/match a value | Excel Worksheet Functions | |||
| find and match the max | Excel Worksheet Functions | |||
Threaded Mode
