Forum Discussion
IFS with nested FIND formulas
New here so forgive me. I'm trying to use a formula to look for a text within a cell. Typically the cell will have XX/6A/XXXX -or- XX/10A/XXXX -or- XX/16A/XXXX -or- XX/20A/XXXX -or- XX/32A/XXX...
I'd create a little lookup table with 6A, 10A etc. in the first column and 1.37, 0.96 etc. in the second column. In the screenshot below it is in F1:G6.
With the values to search in A1 and down, you can use the following formula in B1, then fill down:
=VLOOKUP(MID(A1,FIND("/",A1)+1,FIND("/",A1,FIND("/",A1)+1)-FIND("/",A1)-1),$F$1:$G$6,2,FALSE)