Hi guys,
Im just new to the forum and really require some help.
I have two worksheets, one a project details page and the other the costs sheet. In the project details page I have a cell named 'drawdown_no.' which will be changed to whatever drawdown is applicable. Depending on what the drawdown no. is, the cost sheet will then know which column to take the information from for that drawdown month. For example if i change the drawdown number from 2 to 3, I would like Cell F18 equal O18 and not N18. Im prob not being very clear, but for example:
I would like cell F18 to look at 'drawdown_no.' cell on the 'project details' page.
It should then find the same drawdown no. within the row M on the 'Costs Page'. There should only be one true value.
I would then like the column F to equal whatever the contents is of the matching drawdown column is for each row..
ie. I would then like to tell F18 to be equal to whichever column is true:row18
Long winded I know, justr trying to explain properly....
Image_042.jpg
Bookmarks