View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CJ CJ is offline
external usenet poster
 
Posts: 102
Default 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........