Hi,
I'm successfully using the following array formula to check a cells value against a list (contained in I3:K3843):
{=INDEX($K$3:$K$3843,SUMPRODUCT(LARGE(--(ISNUMBER(FIND($J$3:$J$3843,B3)))*$I$3:$I$3843,1)))}
However everytime I add another value to my list, I need to manually update this formula (from 3843 to 3844 for example). I'm looking to automate this...
In cell L2 I already have a count which outputs 3843. Does anyone know how I can reference this in my formula, aka
$K$3:$K$"value in cell L2"
Any help would be greatly appreciated!!!
Thanks guys
ChainsawDR
Bookmarks