Database Analysis Question
It worked fine for the example I gave, but it didn't work in the my large
spreadsheet. I have rows labeled 1 - 25000, and columns labeled 1 - 150, and
am trying to call and possible row column combo. I.e. Row 4500, column 45
gives a value at there intersection.
"Roger Govier" wrote:
Hi
Try
=INDEX($A$1:$G$4,MATCH(33,$A$1:$A$4,0),MATCH("X",$ A$1:$G$1,0))
--
Regards
Roger Govier
"skier464" wrote in message
...
Hi,
I have the following
Column A B C D E F G
Row
1 Z Y X W V U
2 22 1A 2B 3C 4B 5A 6Z
3 33 1H 3H 4K 7B 8I 9L
4 44 7Q 7N 5M 3P 4G 3E
What I need is if ROW 1 = X and Column A = 33 then the answer is 4K.
This is
for a spreadsheet that is 200 columns by 25,000 rows so I really
appreciate
the help.
Thanks!
|