| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
return proper match from three columns
I have a spreadsheet where I've done an index match to return
criteria. I have to match three or four columns to get the information that I need, so I have three or 4 columns that either have the information I need or a "NO" from the index match. I need a formula to look at the columns and say, if the value is in this column, return it, otherwise go to the next column, etc. also I have the formula IF(ISERROR(SEARCH("FL:",IR3)),"",IR3) but where the "FL:" is, may be "FL:ABC" or "FL:XYZ", with many combinations. so I need to match the 3 or 4 columns, and return the value that contains "FL:" with something else after it. I hope this makes sense. I posted this in a forum, but I have searched and cannot find it. Our server went down at the same time, so I am not certain it posted. Thank you Plus766 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match 2 Columns, Return 3rd, Differing Match Types | Excel Worksheet Functions | |||
| Date formula that will return proper pay day | Excel Discussion (Misc queries) | |||
| match 2 columns and return value of another | Excel Worksheet Functions | |||
| how do i return to normal text from =PROPER(cell) | Excel Discussion (Misc queries) | |||
| Match two columns, return a third piece of data | Excel Discussion (Misc queries) | |||
Threaded Mode
