table array

  1. F

    Does value exist in 2 or more table arrays (VLOOKUP)

    I want find out if B2 in Sheet1 exists in column B or C in Sheet2. If B2 exists in either column B or C in Sheet2, I would like to display Yes or True. If B2 does not exist column B or C in Sheet2, I would like to display No or False. For example: Sheet1 <tbody> A B C (Does value exist in...
  2. L

    VBA not finding correct value.

    Hello, i am working on a VBA that should find a match in the table column A of sheet 1 and match it in a table on sheet 2 and select column 6 cell value. but when i run the code it selects the wrong row and value. what i'm i doing wrong. Sub test() Dim ws1 As Worksheet Dim ws2 As...
  3. G

    VLOOKUP Table Array (different Workbook) Based on Another Cell's Value

    Hi All, I'm trying to VLOOKUP a value in different Workbook (could be Open or Close). However the Table Array information, I would like to get determined by the value of another cell so that in case if I have to change the lookup worksheet & its path in multiple formulas, I would have to change...
  4. B

    Using OFFSET and MATCH to return the correct value

    I have a problem with using the MATCH formula to return the correct 'ranking' from my named array. I have the following: Cell Q3 - with options VL,L,M,H,VH Cell R3 - with options VL,L,MLH,VH Cell T3 should return an overall rating depending on what the user has selected from Cell Q3 and R3...
  5. T

    Constructing new table based on elements of a pre-existing table

    Hi, I am having trouble working out how to construct a new table based on the elements of an existing table. I'm pretty sure it's a combination of VLOOKUP and MATCH but he could also use INDEX. Here is the master table: <style type="text/css"> table.tableizer-table { font-size: 12px...
  6. S

    VLOOKUP formula inside Table_array

    Hello, I am trying to have vlookup search another sheet for a certain value. The problem is I want it to search the sheets in the table_array based on one of the other cells. I want it to look at what value I have in b9, so the formula is =VLOOKUP(DATE(P5,1,1),B9!$A$3:$F$2520,2,TRUE) but when I...
  7. E

    Automatically rename all tables on a worksheet

    Hi all! I am trying to rename all the tables on a worksheet and understand that I need to use VBA to do so.. I'm not very experienced so I was wondering if I can get some help here. Basically the layout of the table is like this: <tbody> Name Part 1 Name Part 2 Column1 Column2 Column3...
  8. S

    VBA: Multiply cells by weights

    I have a large table in the form: <tbody> Months August September October November December August 112 A B C D September 118 E F G October 231 H I November 142 J December 253 </tbody> Which only has diagonal values corresponding to the months...
  9. J

    Vlookup not working - table array turning red with $$

    I could use some help! When I try to do a v-look up on a spreadsheet I've used for 6 months the table array doesn't work. On the spreadsheet I'm pulling from when I go to highlight the columns it turns red and puts $ signs. Then it crashes my spreadsheets. I can't post a screenshot here but...
  10. G

    VLOOKUP table_array wildcard

    Using VLOOKUP, I'm comparing 2 sheets to check if the host is monitored. I extracted the list of guests in sheet1 and the list of hosts in sheet2 Sheet1 A1 Win-2K8-dev1 (335d5188-2e63-44cc-978a-51ea4c90e24c) Win-2K8-mail1 (345d5188-2w64-47cf-973n-53ef459he2rx) .. . Sheet2 A1 Win-2K8-dev1...
  11. J

    Add an extra row to a variant

    Hello, I have created the below code too populate a userform list box. However I am having problems adding a extra row. Function Populate_Listbox_Worksheet() As Variant Dim vaData As Variant nrow = Sheet9.Range("A1048576").End(xlUp).Row If nrow < Range("ProjName").Row + 1 Then vaData =...
  12. B

    Linear Interpolation of Data

    I am trying to write a formula which will linearly interpolate random sets of data in a table. For example, when used on the following table: <tbody> 0 1 2 3 4 5 15 20 0 10 0 15 20 5 20 </tbody> The output (in a separate table) should be: <tbody> 0 1 2 3 4 5 10 15 20...
  13. M

    Max Function find second newest date

    Hello all, I have found how to find the second newest date using the Large function. However it only works when there is only one instance of the date. I have a table with were each date is recorded three times for three different products. When I use =Large(A:A, 2) it returns the max date as...
  14. C

    Vlookup where reference on table array is not in the left most column of the table

    Hi, Does anybody know of a workaround or have previously tried this: To reference a value from one table in one sheet to another table of a different sheet using a unique ID common to both, however the unique ID is not in the left most column of the table array. Thanks. Cailean.
  15. C

    Sort data from one table into two automatically - No VBA

    Hi, I've looked thoroughly throughout forums and tutorials for a possible solution to the following situation, but to no avail. It may have to do with the wording I use in my search, as it's difficult to know how to ask this, but I'm just stumped. I have a list of data, 50-200 rows a week, that...
  16. I

    Vlookup table array equal to last row????

    Hi Guys. Tried so many different fixes for this and i'm just not getting it. I have 2 sheets in my work book. the first names "MC.1" the second named "SQ01" I wish to set up a macro (linked to a button) that once pressed enters a vlookup formula in cell L2 in the SQ01 sheet. the vlookup formula...
  17. RJSIGKITS

    Help with VLOOKUP Table array and DV lists conflict

    Hi Guys - I really need some help with trying to get a VLOOKUP search to return data from a table with the name matching what is selected from a DV list drop down cell - I've tried to attach a mini example of what it is I'm trying to create but it won't allow me to add attachments... So, I have...
  18. M

    VLOOKUP with table array/sheet wildcards

    Hello all, I'm certain this is out there somewhere, but I've done a lot of searching and can't seem to find a solution for this VLOOKUP question. Although, there's also a strong possibility that I'm misunderstanding the available information... I'm trying to do a VLOOKUP using a specific...
  19. F

    Special transpose

    Hi everyone. I have been searching the solution but couldnt find it. Do you know how can I pass from here: <colgroup><col span="12"></colgroup><tbody> 31/01/11 28/02/11 31/03/11 30/04/11 31/05/11 30/06/11 31/07/11 31/08/11 30/09/11 31/10/11 30/11/11 31/12/11 0 0 0 0 1.344 1.060 710 845 85...
  20. oldeirish

    Formula To Show Missing Numbers in a Range

    Hi, I have 3 columns with numbers associated with a person. Some people have 1, 2 or 3 numbers assigned to them within the 3 columns. I’d like to have a 4th column show all the numbers missing from the range of the 3 columns. I’ve tried this array...

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