| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Way to Incorporate Trim Into Match/Index Formula
I have the following formula and am trying to incorporate the trim function
into it; i.e., I want to match the trimmed E2 to the trimmed V:V. Is there a way to modify the formula to do this; haven't been successful yet in figuring this out. Just adding trim in (or clean) doesn't work, at least not how I've tried it so far. =IF(ISNA(MATCH(E2,V:V,0)),"",INDEX(AB:AB,MATCH(E2, V:V,0))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| "Unable to set the Formula property of the Series class" with a tw | Charts and Charting in Excel | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Threaded Mode
