look up match copy paste

  1. I

    Need help with VLOOKUP formula.

    I want it to insert the name from column "C' sheet- 'Assign ASUS HERE' and place the name in "B" of the sheet of the code When I changed the formula it returned "N/A". Any ideas how to fix it? I'm new to excel. =IF(B3="","",VLOOKUP(B3,'Assign ASUS HERE'!$A$2:$B$961,2,FALSE))
  2. S

    How to compare (match) two lists (columns) and when a match is found copy a number of adjecent cells to another location?

    I need to reorder some data I have. I have about a thousand cells with data in a column (say column A) and around 800 cells with data in another (say in column B). All the data are strings. So I need to check for every value of every cell in column A if there's a match in column B. If a...
  3. A

    Macro to index/look up cell and place data onto another sheet

    Hi All, I have two sheets, Weekly Sales and Yearly Sales. Column A on Weekly Sales has the 7 days of the week running from cells A10:A16, On the yearly sales the dates run from cell A3:A368. The idea is that the weekly sheet is populated and then a macro copies all data from the weekly sheet...
    • ardykav
    • Thread
    • index & match look for value look up match copy paste look up related data lookup between sheets
    • Replies: 1
    • Forum: Excel Questions
  4. N

    Please Help with VBA...

    I really need some help with VBA On my sheet Row 2 is where I will enter in the values that I want moved into the table below, based on the EE# I have put into A2. I have a table with raw data below this, each row has a number assigned to it called EE# I would like to have VBA do the...
    • NPA1984
    • Thread
    • look up match copy paste loop match vba vlookup
    • Replies: 2
    • Forum: Excel Questions
  5. C

    LookUp, Match, Get Adjacent Code, THEN copy/paste 3 things

    Need assistance to accomplish the following b/c the code we have now is pulling too much; need this filtering in place asap: Sub IfMatchThenSelectCodeAndPasteAdjacentData() Sheets("PARTS").Select 'Look for only rows that have no colorization present 'If "J3" of the "PARTS" sheet finds a match...

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