vookup

  1. S

    sheet name variable not working in vlookup

    I have multiple tabs and will be moving from one to the next. so I need to have a variable that has the tab name...so that I can use it later. 1. saved the tab name as a variable 2. want to use that saved tab name in a vlookup 2a. the tab name is alaska 2b. the chart that is being...
  2. 9

    Is it possible to do a vlookup by using hyperlink and or hovering over a cell?

    I have a workbook that has over 100 + worksheets that has monthly bonus calculation request submitted (one for each employee), as well as few other sheets that has the current monthly data such as employee info like employee ID, name, department, monthly sales results, etc.. Each worksheet has a...
  3. M

    Some entries with 2 rows of data, some only have one. Take 1st row where there's only one, take 2nd row, where there's 2

    Hi this is my first post here so sorry for any probs! I have a table with rows containing names and associated data, that I need to VLOOKUP into another spreadsheet. Some names have just one row, in which case I need the info from that row, but others have two rows of data and in this case I...

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