Hi Guys,
Quick question - I need to return the value of a particular cell address by looking up a certain value between three cells (A100, A5000 and A7500). For example - in cell A1 I have the value of 4 which either appears in A100, A5000 or A7500 and I need to specify which cell it is. I know i need to use address, index match, but I don't want to match across the entire A100:A7500 array but only look in A100, A5000 or A7500. How do I specify in the match function to not look in an array but to look in only three cells? I need the computer to run this quickly. I would prefer NOT to use three instances of if then, which I can obviously create.
Thanks,
Larry
Bookmarks