Hi, please can somebody help me with a problem I am having?
I am very new to excel formulas and stuggling to work out the following:
I have 2 sheets.
Sheet 1 has partial postcodes in column A e.g "LU1" and a name in column B
Sheet 2 has full postcodes in column A e.g "LU1 3DB" and a company name in column B - I would like to populate column C in sheet 2 with the name that matches the parial postcodes in sheet 1 with the full postcodes in sheet 2.
Any help will be hughely appriciated.
Thanks in advance!
Bookmarks