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?
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
43,452
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,089,371
Messages
5,407,870
Members
403,167
Latest member
LakesideChill19

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top