stefan

  1. T

    Vlookup value based on a name if in one of the tables the name is split in two cells

    Hi guys! I have come across a problem I need to vlookup a team based on the name, however in the table where I add vlookup value the whole name is put in one cell, and in the table where I vlookup value in it is split into two cells: Table 1 <tbody> Value Name Team 10$ Maria D. ...
  2. L

    Add missing value into cell when criteria are met

    Hi All, I have a sheet with data and comments added to it. However, this data is changing and new reports need to be run. However, the comment field is the same for the old data. So i would like find and insert the value in the cells from "Comment" column into the new spreadsheet, as per below...

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