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
Bookmarks