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

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
0
bowemc
Asked:
bowemc
  • 5
  • 3
2 Solutions
 
jppintoCommented:
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
 
Rory ArchibaldCommented:
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
 
jppintoCommented:
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
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
Rory ArchibaldCommented:
I completely agree with jp here. Would you like me to get this reopened so you can split points, as that seems fairest?
0
 
jppintoCommented:
For me, that would be the solution...
0
 
jppintoCommented:
Rory, should I "Request Attention" on this one as the author is not responding?
0
 
Rory ArchibaldCommented:
Up to you. It all evens out in the end. ;)
0
 
jppintoCommented:
:) I will request attention on this one... thanks for your support, as you said, it all evens in the end!
0
 
modus_operandiCommented:
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
EE Admin
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now