Hi,
How to modify this funtion to find or search for the word, regardless if word is capitalized or not
=IFERROR(INDEX('WBS Extracted'!D$14:D$5000,SMALL(IF(ISNUMBER(FIND(G11,'WBS Extracted'!$D$14:$D$5000)),ROW('WBS Extracted'!$D$14:$D$5000)-MIN(ROW('WBS Extracted'!$D$14:$D$5000))+1),ROWS($F$13:$F13))),"")
G11 = Agency
Through the, 'WBS Extracted'!$D$14:$D$5000 worksheet, the word "Agency" may be given as, "Agency" or "agency"
How to modify so it's not case-senstive?
Thanks
Bookmarks