not sure if you still need this but here is an option =IF(A2="SCREWS","HARDWARE",IF(A2="NUTS","HARDWARE",IF(A2="BOLTS","HARDWARE",IF(A2="BRACKETS","HARDWA RE",IF(A2="NAILS","HARDWARE",IF(A2="DESK","FURNITURE",IF(A2="CHAIR","FURNITURE",IF(A2="SINK","PLUMBI NG",IF(A2="FAUCET","PLUMBING")))))))))
just added the other last four as examples of multiple departments
hope this help can do something similar with vlookup but it uses more resources, this is often a quicker solution
Hi NEW PERSON
Welcome to excel forum
The post is from 2008 I doubt if you wil get a reply
The thread dates are displayed in the top left of the posts
regards pike
If the solution helped please donate here to the RSPCA
Sites worth visiting;
J&R Solutions - royUK
AJP Excel Information - Andy Pope
Spreadsheet Toolbox
VBA for smarties - snb
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Bookmarks