lookup and merge

  1. H

    Need Help with Formula for Payment Status Update in Excel

    I am working with an Excel spreadsheet that tracks client orders and payments. I have two sets of columns: one for client names and their ordered quantities, and another for client names and their paid quantities. I need assistance with a function that accurately updates the payment status based...
  2. J

    Lookup and merge vba code

    Hi brains trust I’m struggling to develop some code that I’m hoping someone here could help with please… I have a spreadsheet of books and their data in columns A-AZ I have 20 different book genres in column F I have 200 book titles in column P Each book title has its own row (therefore...
  3. T

    Merge Data from Two Tables Based on a Lookup Value

    Hi, I have two tables that have one column with similar values. I need to create a table that would merge the data from both the tables based on the matched values. I have prepared a Sample Sheet. https://www.dropbox.com/s/wq1nin6x6v0gfxg/Sample%20for%20Help.xlsx?dl=0 Concatenating the...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top