Thanks for the reply, I would rather not upload the document as just about everything in it is sensitive material, but I can paste the code here and see if that helps.
=IF(LEFT(A3,2)="LV","Living",IF(LEFT(A3,2)="DE","Decor",IF(LEFT(A3,2)="DN","Dining",IF(LEFT(A3,2)="BD","Bed",IF(LEFT(A3,2)="LT","Lighting",IF(LEFT(A3,2)="BA","Bath",IF(LEFT(A3,2)="KT","Kitchen",IF(LEFT(A3,2)="HW","Hardware",IF(LEFT(A3,2)="OF","Office",IF(LEFT(A3,2)="TL","Flooring & Tile",IF(LEFT(A3,2)="FL","Flooring & Tile","")))))))))))
Bookmarks