CALLING A RANGE OF CELLS FROM EXTERNAL SOURCE

A

ANGELICA

Hi all,

This is what I need to do:
In the talbe that I have, I want to have a cell where every time I enter the
name of a country, the information of only that particular country (which I
have stored in another sheet, same workbook) appears in a range of cells
(A5,B5,C5,D5)...Kind of a sub-table......I have tried many ways but it's late
and I wanna go home!!!
Help Please!!!
 
E

Excelenator

Have you tried VLOOKUP? If you have a range on another sheet called
"CountryInfo" that contains the columns (country, col1, col2, col3
etc)
you could simply use the formula

Col A
USA

Col B
VLOOKUP(A1,Sheet!2'CountryInfo',2,false)

Col C
VLOOKUP(A1,Sheet!2'CountryInfo',3,false)

Col D
VLOOKUP(A1,Sheet!2'CountryInfo',4,false)

etc.

Hopefully this will resolve your issue and you can go home!!
 
Top