Home » Forums » Open Source Learning Center » Question and Answer

Mutiple Look Ups

Submitted by Affy99 on 3 February, 2016 - 09:30

Hi All,

I'm stuck on a spreadsheet I'm creating and wondered if someone could help.

I have a list of 192 countries. This list is definitive and used for all clients however not all clients will have a value in each country.

What I want to achieve is a lookup that only shows the countries that have values.

I have tried NestedIFs but I can only get it to find the first country ad none subsequently. Given that there are so many countries, the formula gets horrendous too. I've tried VLookUp but again, this needs to be done in a way that I would have a list of 192.

Is it possible to have a new worksheet which fills in from say cell A1 the country and cell B1 the value but ONLY for the countries which have values in the other worksheet?

Thanks in advance for any help.

‹ Editing Code to peform 5 steps to every highlighted cell in a column Formula and Conditional Formatting ›
»

Hi Affy99, unless I am

Submitted by mec1981 on 4 February, 2016 - 01:55.

Hi Affy99,

unless I am misunderstanding your needs, is there any reason why a pivot table won't resolve this?

Regards
Mark

»

Hi Mec, Possibly, I have

Submitted by Affy99 on 4 February, 2016 - 08:52.

Hi Mec,

Possibly, I have never really used pivot tables - Is there a tutorial somewhere?

Thanks,

Affy

»

Hi Affy, Sorry for slow

Submitted by mec1981 on 9 February, 2016 - 06:20.

Hi Affy,

Sorry for slow response, there is a pivot table lesson on this site. I have attached link below:

http://excelexperts.com/Teach-Yourself-Excel-Lesson-25-Create-A-Pivot-Table

Regads
Mark

»