lookup and copy paste

  1. S

    Find and replace a cell value if another cell value is higher

    Hi All, Hopefully you can assist please as my VBA skills are unfortunately lacking in this area. I have a spreadsheet with 2 values in different columns, What i'm trying to do is... Where the value in column S is greater than the value in column F, i want to replace the column F value with...
  2. L

    Match cells between documents

    Hi All, Firstly, I'm sorry for cross-posting, but please I want help for my problem I have 2 excel files, 1 and 2 (see attached files) In 1, there are multiple sheets, named according to group names for students, and in each sheet, there are student names and their group names (two columns...
  3. V

    Help with Lookup Function

    I need help building a lookup function. I have 4 columns. Column A is the number value I want to lookup on column C to find an exact match. When found, I want the text value on column D to be placed on Column B. Any help would be greatly appreciated.
  4. A

    VBA to hard copy a value from a stationary cell to another cell based on a date

    I have been wracking my brain and cannot see how I can do this: I have a report updated weekly Report Date 01/03/19 Value for that week 200 i have a set of weekly dates in columns with the total for each week ie "I" "J" "K" "L" "M"...
  5. S

    Lookup date in ws1 and find same date in ws2 copy and paste

    Hi. I have an worksheet that is updated every week. However, I want to copy and paste the values from 2 different cells into another worksheet. Worksheet 1 will have a date entered in cell H1. I want to find that date in Column A on worksheet 2, and then I want it to copy the value (as the cell...
  6. N

    Track number from a list and copy paste the value's

    Hi Guys! Excel is giving me a hard time. I hope you guys could help me find a solution. I have a grocery list like in the picture below in Worksheet1. The one below is simplified but actually it exists out of 1000 numbers with different discription, units and amounts. The worksheet1 one...

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