If and then or similar

Nateforexcell

New Member
Joined
Oct 25, 2019
Messages
2
I have a workbook that has 400+ business names with 20 to 30 products each, I really need to add business names to another column,

Column a (business name)
Column b(product name)
Column c (hopefully business address)

Am I stuck with copy and paste?
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
42,312
Office Version
365
Platform
Windows
Welcome to the MrExcel board!

From your description I am unable to be sure what you have, where and what you want to achieve, and where.
Any chance that you could show us a small set of copyable sample data & the expected results with any further written clarification?
My signature block below has help on how you can do that.
 

Nateforexcell

New Member
Joined
Oct 25, 2019
Messages
2
Unfortunately, the workbook is proprietary. Basically, I have a long list of multiple products in rows, I am creating a searchable table, I got the list that has the business name, product, details about product in different columns. Need to add the business address in separate column. I have been searching via the internet to get the business address, copying and pasting to match the business, its tedious to say the least. I was hoping I could create a way to tell excell, if column A says (business name) the the next column should say (business
address address), even if I need to create a key. It looks like the product offerings will change often and I am not always going to receive an address with the new update, so copying and pasting 6k to 7k rows of different addresses every time I update the listings is going to be brutal. There is about 400 to 500 different businesses. All that have 20 to 30 products. I currently have them in alphabetical order which helps, but still hours of coping and pasting.
 

=ODIN=

Active Member
Joined
Dec 3, 2009
Messages
288
I may be completely misunderstanding this, but it sounds like this might just need a vlookup formula in the Business Address Column.
 

Forum statistics

Threads
1,082,548
Messages
5,366,227
Members
400,880
Latest member
dwb

Some videos you may like

This Week's Hot Topics

Top