Ahh, you really shouldn't multi-post. See another option using OFFSET (albeit
volatile, it requires only a single reference cell to anchor the source
table) in your multi-post in .worksheet.functions.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"skier464" wrote:
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!