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

Could you upload some sample data?

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

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).

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

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