lookup and return data from one table to another based on a cell reference.

Morning all,

I am trying to create a workbook that is able to change the data returned based on the station code placed within another cell.

I have attached the workbook.

what the formula needs to do is on the sheet "DS Data" when the DS code changes in cell B2 then it pulls the correct data for each week into each table from another sheet. in this instance it would be the "Ranking DPMO Data"

This would mean that if the code in B2 changes then so would the data to the correct DS code.

Any help would be greatly appreciated.

That's Fantastic, Thanks for your Help.

Is there a way to alter this formula to take into account the 1.1 column rather than the 1 column? many thanks