Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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........ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Manual control of link updating for downloaded quotes? | Excel Discussion (Misc queries) | |||
auto updating list | Excel Worksheet Functions | |||
Subtotals in a list | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |