Extract data value using pick list
Hi Groupies
I have a spreadsheet similar to the following example:
H1 H2 H3
A101 A E I
A102 B F J
A103 C G K
A104 D H L
I would like to use a couple of pick lists to be able to select a row and
another to select a column and then have Excel return the intersecting value.
So, if in the first list I select A103 and in the second one I select H2, I
would have G in my found value.
I was thinking that the Index function would work, but I am just getting
#REF in my result. I was sure that I have done this before, but perhaps not.
Thanks in Advance.
--
Thanks for the brainwaves!
CJ
I blame the parents........
|