#lookups

  1. C

    Matching two columns with slightly different data

    Hi, I have two lists of Accounts that I need to consolidate. These lists come from two different sources and in a lot of cases the individual names are slightly different. Ie One list has 'AC Nielsen', the other one has 'Nielsen Media'. The best tool I have found so far is a partial Vlookup...
  2. khawarameer

    Lookup one value in two lists and identify corresponding values

    Hello All, I am looking for a formula which will look a value from a two lists and list its corresponding value in result. Please refer the table below <thead> Lookup Value </thead><tbody> Item_1 List1 Lsit2 Item_1 Item_2 Item_3 Item_1 Item_1 Item_3 Item_2...
  3. A

    Inventory report to reflect increases (reciepts) and decreases (returns) seperately

    Hi There, I have an inventory report, that performs a lookup from each day's inputted data (each day has a sheet where that report is inputted). In the summary sheet, I am looking up the on hand from the day before and subtracting the on hand for today. This gives me the total items shipped...

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