1. K

    VLOOKUP when table_array is a Table

    Is there an easy way to connect VLOOKUP from defined Table to another defined Table? Is there a better function to do this? I'm trying to get away from using relative cell/column locations. When I do a VLOOKUP in a table and reference another table, I get something like the...
  2. J

    variables in .formula vs .formular1c1

    Trying to sub a variable into vlookup for the table array. This works: Sub vl() ' temporary fix for summer teach Dim vl1 As Range Dim vl2 As Range Dim vl1a As Range Set vl1 = Range("A:A").Find("C.I.") Set vl2 = Range("B:B").Find("17200") Set vl1a = Range(vl1, vl2) MsgBox...
  3. J

    setting table array in vlookup using find

    Hi all, New to VBA, learning a lot already. Here's my situation: I'm trying to write a vlookup where I know what the text in the first and last cells in my table array are, but not their cell address. I've tried to fix it by using a variable for my table array. Sub vl() Dim vl1 As Range Set...
  4. M

    VLookup Table_Array Not Playing Well for ServerPath/File Concatentation

    Hi all, I have scoured through countless posts hoping to find a solution, but I have failed. The problem seems to be that concatenate adds "" around the table_array which messes it up. My goal is to search a specified excel file for the yesterday's date. It will be in the 'E' column in the...
  5. D

    semi-variable table_array (without vba) in vlookup?

    Hi, I have a huge list looking like this (3 columns): <tbody> asset ID (A) Step (B) ID (C) 7148 03 LOOK 0 7148 01 MODEL 1 7148 04 RIG 2 7148 06 SETDRESS 3 7148 05 SHAPES 4 7148 02 TEXTURE 5 7147 03 LOOK 6 7147 01 MODEL 1007 7147 04 RIG 1008 7147 06 SETDRESS 1009...
  6. A

    Using VLOOKUP to pull info from another Worksheet - Not working!

    Hi there, I've input this formula to take data from a cell on one worksheet, and pull it into another cell on another worksheet. =VLOOKUP(R3,'[uk_beauty_browse_tree_guide._TTH_.xls]BEAUTY PRODUCTS (11.2.2016)'!$A:$B,1,FALSE) R3="Pedicure" The other worksheet Table_Array of Column A & B...
  7. P

    Change Table_array Automatically in Excel Lookup Formulas

    Hi, I am trying to improve a template that will be used by alot of people on a weekly basis, and my goal is to make it as automatic as possible. Some columns need to be updated every week by the users, currently by changing the cell reference (marked in red) in this formula...
  8. P

    Returning two values from a table array based on a value

    I'm trying to return 2 values from a table selection, based on a value i.e. if I look up the table for "Team 1" - i'd like to return Team 1 v Team 6, Team 9 v Team 1, and so on, to a Fixtures Section in a different area of my Excel Sheet. However, the look up value "Team 1" could be in column...
  9. S

    VLOOKUP Function's Table_Array Argument

    I am using the VLOOKUP function in a worksheet named REC-ISS in a workbook named EE-Cardex.xls. However, the Table Array to be referred is B22:P33 in different worksheets, in another workbook named MPR-Jun10.xls. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office"...
  10. S

    Vlookup using VBA Constants

    I want to use a VLOOKUP formula to pull data from additional workbooks. I would like to use constants/dimensions in VBA to reference the “table_array” in the formula. The pathways will always stay the same but the name will change to the date. The formula will bring back the data but I have to...

This Week's Hot Topics

  • separating multiple Proper names (uppercase letters) from a list
    I have a list of proper names that only has spaces between their first and last names. I need a formula that can separate these names into...
  • 'for' Loop
    Hello guys, I am trying to do something new. With the help of a VBA code, in every case, last 2 Values of last 2 cells of columns D-15 to D-28 to...
  • Open specific pdf in folder with vba
    Hi, Below is the code in use , unable to find rich icon to put code inside using a mobile. The code in use is shown below. Everything works as it...
  • What is wrong with this For Loop code?
    I am trying to loop through each cell in Column U from U4 to last row to check if the percentage in the cell is greater than -.050%. In a...
  • Data to match
    Hi there, I have created 2 worksheets with data. First is all materials used and second has the bottle type used for each of material. How can I...
  • Shifting Columns
    Hi Dear Community, I'm trying to find the best way to Shift (Cut - Paste) all the information below and to the right of the "Worker" cell in VBA...

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