CALLING A RANGE OF CELLS FROM EXTERNAL SOURCE
 

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!!!

CALLING A RANGE OF CELLS FROM EXTERNAL SOURCE
 

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!!


--
Excelenator


------------------------------------------------------------------------
Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768
View this thread: http://www.excelforum.com/showthread...hreadid=565422

CALLING A RANGE OF CELLS FROM EXTERNAL SOURCE
 

Thank you very much....sorry for my late response;)

"Excelenator" wrote:


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!!


--
Excelenator


------------------------------------------------------------------------
Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768
View this thread: http://www.excelforum.com/showthread...hreadid=565422