Range Formulas - Help!!!!!!!!

[mel]

Hi,

We are building a model for the international finance team.

In the P&L workbook, we want to have a front summary page, where yo
can select a single country (from a pivot table list) and be able t
see the P&L summary instantly.

We have gone through the process of naming all the ranges by eac
individual country. Now that we are trying to use the vlookup formul
to get the correct data in the summary page, we don’t know how to lin
the range to the list (which is a single cell).


For example,

= vlookup(A23,UK,3,false)


It is the UK range name that we want to change, the change is indicate
by the change in country selection from a list.

Any ideas?? All help *MUCH appreciated…….

 

[Bob Phillips]

Hi Mel,

Try this

=VLOOKUP(A23,INDIRECT(A7),3,FALSE)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Frank Kabel]

Hi
if you store the range name in cell A1 change your formula as follows
= vlookup(A23,INDIRECT(A1),3,false)
Note: This only works if the range is in an opened workbook (or of
course the same workbook)

HTH
Frank