IF THEN QUESTION

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

New to EXCEL. I have 25 worksheets listed consecutively. What's the formula
for the following scenario.

If j7 in worksheet 1 is 20, I want it to go to worksheet 20 and obtain a
number from a given cell(lets say d39). If later I change it(j7 from
worksheet1) to 3, I want it to go to worksheet 3 and get a number from a cell
(d39). In other words, J7 will change once a week and I want to make sure
that it goes to the worksheet specified.

Thanks in advance.
 
This is a FrontPage newsgroup, suggest you post to the Excel newsgroup.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
URL?

--
;-),

Kevin Spencer
Microsoft MVP
..Net Developer
Who is Mighty Abbott?
A twin turret scalawag.
 
Back
Top