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...
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>...
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...
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...
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...
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...
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...
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 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.