Cell Value within a Formula

[santeria]

Is it possible for a Formula to pickup a key value based on a Value within a separate cell.

For example.

=VLOOKUP(A1,MONDAY!$A$1:$AZ$20,2,0)

Relates only To Monday, if the Cell, a cell , could be inserted so that MONDAY becomes an easily ( I hope) changed variable, that would help a great deal.

Thing is, I can;t get the syntax that would allow the cell value to display within a vlookup like that.

Has this been done before, or is it a screwy idea ?


Ta

 

[just_jon]

Have a lookup at INDIRECT, as in --

=VLOOKUP(A1,INDIRECT("'"&B1&"'!$A$1:$AZ$20",2,0)

where B1 houses your sheetname.

 

[Guitarde]

If your different ranges are not the same sizes on each page (a1:az20),
you can define some named ranges "Monday", "Tuesday" for each page.

Then type the range name in B1 and use =VLOOKUP(A1,INDIRECT(B1),2,0)

 

[santeria]

Ta

I'll give that a Go...

Sounds like the way !!!

ray: ray:

 

[santeria]

The datasets are exactly alike, so Just Jon's Formula Does the tricK...

=VLOOKUP(A1,INDIRECT("'"&A22&"'!$A$1:$AZ$20"),2,0)

Is the Key Format... I think All I added was the extra bracket

Now I can Move between 5 Pages of data Quite Easily, No Worries
All on one page.

Ta muchly.