# Grade-Counrty pair lookup in Grade-Counrty table

Hi,

I've attached a xls file with my question. I've a table of Grade-Counrty values in a table.

In a seperate table I've Country-Grade pairs and need to pull the Country-Grade value from the first table using an incell function. I think it needs a Vlookup with an embedded match and offset, but I can't seem to get it going

Thanks
Excel-Question.xls
###### Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
Here's the formula:

=SUMPRODUCT((\$C\$5:\$C\$7=E14)*(\$E\$3:\$H\$3=F14)*(\$E\$5:\$H\$7))

Please take a look at the attached file.

jppinto
Excel-Question-1-.xls
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Commented:
If you want a version you could use with non-numeric data:
=INDEX(\$E\$5:\$H\$7,MATCH(E14,\$C\$5:\$C\$7,0),MATCH(F14,\$E\$3:\$H\$3,0))
in G14 and copy down.
0
Commented:
With all due respect, can you please explain why you (only) accepted Roy's solution? My solution works for the question that you've posted, that is to retrieve a number. You didn't mentioned that you wanted to retrieve non-numeric data on your question, so my solution works for the question that you posted.

If you want a solution also to retrieve non-numeric data, than you need to use Roy's solution, but this is not the case. If it were, you should at least give me an assist on this one because I provided a working solution for the question posted!

Hope to ear from you...

jppinto
0
Commented:
I completely agree with jp here. Would you like me to get this reopened so you can split points, as that seems fairest?
0
Commented:
For me, that would be the solution...
0
Commented:
Rory, should I "Request Attention" on this one as the author is not responding?
0
Commented:
Up to you. It all evens out in the end. ;)
0
Commented:
:) I will request attention on this one... thanks for your support, as you said, it all evens in the end!
0
Commented:
bowemc,

I have reopened your question and started the process of closing it with a split amongst two or more Experts, as that outcome seems more equitable than your original disposition.

modus_operandi