# Need Help With a Multi-Step Conditional Statement Referencing 2 Sheets in a Work Book.

1. ## Need Help With a Multi-Step Conditional Statement Referencing 2 Sheets in a Work Book.

Okay, So this is a little complicated to explain but I'll do the best I can.

I have two sheets in a work book. One of which is a table that has numbers 0-20 (X') and a number that corresponds with each (Y') (Not derivatives, just using that for notation)

Now, in another sheet I have a data sheet of various information. In this sheet, a number 0-20 will be manually input by the user in cell F24, we'll call that X. Now, what i want to do is have a statement where

IF G10 = "UP" then put which ever Y' number corresponds to X=X' in cell F32 and if G10 = "DOWN", cell F32 will equal Y'+F10 using the Y' that again corresponds with X=X'.

I hope this makes sense, and any help is appreciated.

Thank You

2. ## Re: Need Help With a Multi-Step Conditional Statement Referencing 2 Sheets in a Work Book.

Could you upload some sample data?

3. ## Re: Need Help With a Multi-Step Conditional Statement Referencing 2 Sheets in a Work Book.

Here is the file, The X, X', and Y' are labeled

4. ## Re: Need Help With a Multi-Step Conditional Statement Referencing 2 Sheets in a Work Book.

Just realized that the X in the "Size:" box is just referencing the input of F24, which is more or less hidden in the Page 1 in the middle of the page... I hope it hasn't confused you as to which X i was referencing in the first post. F24 is the manual user input (0-20).

5. ## Re: Need Help With a Multi-Step Conditional Statement Referencing 2 Sheets in a Work Book.

Look at the attached... is this what you were looking for?

The formula I used was:

=INDEX('Installed Height'!G5:G25,MATCH(F24,'Installed Height'!B5:B25,0))+(G10="DOWN")*F10

Dan

6. ## Re: Need Help With a Multi-Step Conditional Statement Referencing 2 Sheets in a Work Book.

That seems to do everything I wanted it to. Thank you very much.

7. ## Re: Need Help With a Multi-Step Conditional Statement Referencing 2 Sheets in a Work Book.

Awesome! Remember to mark your thread as solved, and throw a Star my way if you feel like it.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1