Table Array Search [2]

Hi All:

I asked a similar question in another thread, but it is a different problem. I considered adding on to that one "Table Array Search", but some moderators don't appreciate multiple questions in one posting, even if related, so thought I'd start a new thread with [2]. Hope this is OK?

In any case, please see attached image. If the end user inputs Sign 1, and Sign 2, I need a function to seach the columns and rows and find the strength number.

Example:

Sign 1: Monkey
Sign 2: Tiger
OUTPUT: 2

Sign 1: Dragon
Sign 2: Rat
OUTPUT: 10

How would I write this function?

Thank you so much!

Assuming Sign 1 in H43 and Sign 2 in H44, use the following formula:

=OFFSET(H30,MATCH(H43,I30:S30,0),MATCH(H44,H31:H42,0))

Also, look at your original post, I put a formula there that doesn't require helper cells.

- Clay Ver Valen
Excel Help

Clayv:

You rock! This works great, and so does the other formula in the other thread. You're a genius! Nice work! Much appreciated.