• Status: Solved
• Priority: Medium
• Security: Public
• Views: 205

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
0
bowemc
• 5
• 3
2 Solutions

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

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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.