Using the Match Function when items are not displayed in a perfect array?

[larryg003]

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

[Special-K]

Simplest way is three IFs.
If you know the value is/may be in one of those cells just check those cells.