match value

  1. S

    Match value with other value in difference sheet

    Hi guys, Could you help me, please? I have a big data and many row. I have 2 sheet, sheet 1 have column name, netto and fee. Sheet 2 is like sheet 1. But field from sheet 1's not like sheet 2. Sheet 1 have data cell in netto, sheet 2 have data cell in fee. My expectation result if Neo A have...
  2. Z

    VBA to colour cells if they are equal to or greater than another worksheet cell value

    Hi All, Please could you help me. I am trying to loop through the rows in my worksheet and then if the cells in a column match a value in another worksheets cell then I need it to change to colour of the cell. My Main table has about 50 rows and the headers start in row 2. There are 23 Columns...
  3. R

    How to search for keywords in a column and return the values from the column next to the value found?

    Hello, I have the following Excel data and I would like to return the repeated values found when the user searches for keywords. It can be a formula and/or VBA code. To be considered: 1. Column A and B have fixed values. 2. Column C and D are the keywords that the user will enter (not...
  4. B

    Automatic Hyperlink between two rows based on matching content in field

    I have what would seem to me to be a simple request, unfortunately not for me. :eeek: I would like to write a VB script that will take the Value in Column A and find its match in Column B in the same excel sheet and create a dynamic hyperlink to it. I have 100s of values in Col A sorted in...

Watch MrExcel Video

This Week's Hot Topics

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
Top