Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Worksheet references in Excel 2000

Comment:

I have three worksheets, named X, Y, Z, that contain data to be looked up. On my main page, I have a cell that contains the NAME of the worksheet I want to look up. Let's assume the value of the cell is Y. Now, I want to create a formula to lookup a cell A1 on the sheet referenced above. I realize I could use the formula (some of it is missing): =LOOKUP(value,'Y'!A1,.... but in this case I want the value of another cell to specify the sheet name; I don't want a constant value for a sheet name in the lookup formula. Help!

Reply:

It doesn't really sound like you need a formula. Why don't you just hyperlink the cell to a "Place in this Document" and specify the cell reference there?

0

Windows Installer Problem...

Slow Login from XP to 200...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Hello: I am a self-taught private developer and have produced an extensive spreadsheet that relies on a variety of VB macros that are accessed through a detailed macro-generated Custom Menu Bar that a...

Summary: Hello, I'm using MS office 2000, and in Excel i'm trying to come up with a formula combining 'COUNT' and 'IF' but can't seem to get it right. I would like to be able to select a certain amount of cell...

Summary: How do I clean up (besides sorting and doing it manually) duplicate entries in Excel? For example, I have: A B 1 bill cas 2 bill vm 3 sue vm 4 sue cas 5 sue vm 6...