vlookup #name?

  1. F

    Names on two different sheets, trying to look up value

    I have two sheets with names on them. One has just names (names of sales people who just made a sale) and the other has the names of sales people with the amount of sales they had over the past 12 months. I pull data regularly to see who the most active sales people are. I want to be able to...
  2. S

    Search Formula

    What formula could i use to to find names in a of information? Would using a index and match make more sense than a Vlookup or something Else? I'm trying to say if the information in column A appears in Column C, Appear in Column B <tbody> Column A Column B Column C <tbody>...
  3. S

    Attendance Sheet

    Hello everyone, I am a little stumped at this point and I have tried multiple things (maybe I need some coffee lol). So I am building an attendance sheet for my company to use across the network. I am trying to make it more user friendly. We use a point system when it comes to attendance. I am...
  4. M

    Vlookup Function or perhaps there is an easier way

    So for example I have a spreadsheet with around 20000 part numbers and titles. On the first sheet they have the correct part #, but not the correct title. On the second sheet I have the same part numbers with the rite title as well with a bunch of other information which I need. I know I could...
  5. F

    VLOOKUP/IFERROR - lookup values

    Hi, I have vlookup ActiveCell.Formula = "=IFERROR(VLOOKUP(R2,'" & sfullpath & "'!" & Rng & ",3,0),""Other"")" and it's working. But I don't want to start from R2. Possition is choosen before and it's called rows_x_begin: for example: rows_x_begin = 26 so it should be R26 how to add...
  6. B

    Vlookup #NAME error using vba

    Hi everyone, I want to use variables I declared in the actual formula of the print cell. For instance, this code works fine without errors - HOWEVER, I want to use variables "rownum" and "colnum" as cell coordinates to find the lookup value, i.e the first argument in the vlookup equation...
  7. D

    Trying to combine IF and VLOOKUP Functions

    Hello! I'm using Windows 8, Excel 2013 for a class homework assignment, but the directions are unhelpful. I've combed through excel forums and videos for hours and have found many videos -related- to my problem, but none that have helped me really address and fix it. I have two spreadsheets in...
  8. W

    #NAME? Doesnt like the way i've referenced my VLOOKUP Range in VBA

    I need to be able to place a number 1-28 in a cell and have my VLOOKUP reference that worksheet (1-28) and range A1:AK40 on all worksheets. Here is what i have and I get #NAME? which makes me feel like i'm pretty close. I dont yet have the Range A1:AK40 for the worksheets, but i figure i'll add...

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