Can anyone help with an Index & Match formula that would allow me to find and match a specific number contained in a sequence which may contain any number between 1 and 12 or a letter.
The cell will contain numbers or letters in a sequence of 1v2 (no space) 3v4 etc. up to 11v12 or a combination of these numbers.
This formula works for a single number =IF(G5="","",INDEX($L$5:$L$8,MATCH($G5,$K$5:$K$8,0)))
but not what I am after.
Many thanks for any help that you can give me.
Please do not use code tags with formula - - these are reserved for use with VBA code only.
Code tags removed. Thanks.[/COLOR]