Hi
I need a formula that will look at the list of postcodes on sheet 1.
And tell me the name of the rep covering that postcode (row 1 sheet 1)
I would like the sheet 1 to be hidden and sheet 2 to have the query on?
Please see attached sample.
Thanks
Bookmarks