Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match with or without "S" ending
Hello, Here's my formula for an index and match where cell G1 has the data of Development Cost. =INDEX($A$1:$B$7,MATCH(TRIM(G1),$A$1:$A$7,0),2) What's an improved formula for matching $A$1:$B$7 to include Development Costs <<< with the "S" at the end? Sometimes, a person omits or adds "S" at the end and this formula doesn't recognize it. I don't want to trim off column G datas with "S" ending because some words do require a "S" at the end ie. Utilities. Thanks in advance, Ricky -- ExcelQuestion ------------------------------------------------------------------------ ExcelQuestion's Profile: http://www.excelforum.com/member.php...o&userid=34059 View this thread: http://www.excelforum.com/showthread...hreadid=538567 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match Index | Excel Worksheet Functions | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
Find a match that;s not exact | Excel Worksheet Functions | |||
Vlookup, Index & Match | Excel Worksheet Functions |