CALLING A RANGE OF CELLS FROM EXTERNAL SOURCE

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

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

[ANGELICA]

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