Home » Video » ...

How to vlookup tab name Videos

Excel: Reference a sheet name in a formula using the INDIRECT Formula

This video shows how to us a reference in a cell to refer to a sheet name.

User Comments

Milk Meister commented on 01 May 2013

You don't actually explain what all these quotes / parenthesis are about, it just looks like a complete mess & you don't help by tripping up over your words on the parts using them.

vicky4hi commented on 09 Apr 2013

Hey how can i make change to the B3 used in the formula, if i want to get amounts from different cells

edayers315 commented on 15 Apr 2013

Stacy, thank you for this video. It helped me solve a problem.

Ahmed Gendy commented on 14 Oct 2015

Thank you. Wonderfull

vizlo888 commented on 28 Apr 2013

Thank's.

Excel Magic Trick # 146 part 1: Dynamic List from Table #1

See how to how to extract records from table and put 1 record on each sheet with records in rows. See how to use the functions; VLOOKUP, COLUMN, FIND, ...

Excel Worksheet Navigation Tips

//www.contextures.com/excelworkbooktips.html Visit this page to get more Excel workbook tips. It can be difficult to find a specific sheet, if an Excel file has ...

User Comments

Doug H commented on 23 Aug 2015

Nice tips, especially the tab spacers!

ExcelIsFun commented on 19 Aug 2015

Great tips!

NUH ZAKİR (‫عبد الله‬‎) commented on 20 Aug 2015

thank you

pmsocho commented on 20 Aug 2015

Cool!

Excel VBA Basics #9 - Declaring variables with DIM and using SET to abbreviate worksheet name

In this video, we learn how to tell Excel what type of variable we're using, and then it gives us feedback by allowing autofill dropdowns and giving previews of ...

User Comments

ExcelVbaIsFun commented on 11 Jun 2013

Here are some solutions if your mouse over the variable doesn't show a result. 1. You have something wrong in your code and vba is trying to tell you by not letting you see variable values. Click Debug>Compile VBAProject. That should reveal errors/mistakes. 2. Maybe you have a search window or iexplorer window open that may obscure this function? Google the search term "excel vba 2013 mouse over variable"

Scott Marshburn commented on 24 Sep 2013

I have noticed that if there is a value in column A1 thru C1 then If A2 is blank And B2 thru C2 has a value. The last row is 1 . Is there a way to Identify the last row if there is data in any column no mater if there are blanks? For example A1&B1 has a Value, Then B2&C2 has a Value it would see the last row as 2 ?

ExcelVbaIsFun commented on 22 May 2013

In the VBE go to Tools > Options > Editor Tab. Make sure that "Auto Data Tips" is ticked. If it still doesn't work, make sure key variables are declared using Dim. If it still doesn't work, try having excel find any errors for you by clicking Debug > Compile VBAProject. Thanks for watching. Dan

Jason John commented on 09 Jul 2013

Hi Daniel, great video! A quick question: Can I say that "SET" is only for abbreviation purpose. I mean I don't have to SET a worksheet to show the result of a variable when I put the curse on it. At 2:13 there actually is a value showing next to the curse. Thanks in advance

ExcelVbaIsFun commented on 09 Jul 2013

Yes, "set" is to shorten the typing, to abbreviate. I find that if I declare (DIM) a worksheet and set it to that variable, the things I want to hover my cursor over appear for me. I find when I don't, they don't. Thanks Jason!!

Walt Bernal commented on 21 May 2013

Thank you for the VBA lessons, i'm learning a lot. question for you. what settings do you have for the cursor to show the values when you put the cursor over the word or statement?

Jason John commented on 09 Jul 2013

Actually even if you don't, they still appear. At 2:12 of this video the value flashed by really quickly when you put your cursor on it... maybe that was not the value you wanted?