H or V Lookup probs

Hi all

On the attached file " Potholes ", on the "Front End " Tab if you enter a number into Cell ( the Yellow Cell ) C7 it needs to lookup the " MASTER " page for data, and return it to the RED cell,

NOW in the Master page looks at MANY OTHER Pages I have only included " Sheet1", there will be at least 6 more pages to transfer the ALL of the data Via Link as some data will change, across to the Master page.

I trust someone can assist


Peter

See changes in Column B of Master Sheet


Kind regards
Leo

Good Morning

Boy am I glad we are not involved with the BREXIT down here.

Thank you for your reply and fix, however I have something like 2000 lines the I need to edit to add the word value and the brackets either end etc, just by chance a quick fix to add the extra word to all 2000 lines. ??


Peter

Maybe this is somehow quicker, no changes need in other sheets

Code after WorkSheet

Please Login or Register  to view this content.