Search results

Hello I am working with structured references (tables). I have a table, (example enclosed), that contains data. I have kept the example simple. The table is a data table with one column called Number. The table name is Table1. For the application I am trying to address, this example table...

Hello I have attached an example file. I am trying to code a user defined function, (UDF), where I am looking up, and concatenating a first name and last name, based on initials, in a table. My issue is that the table will not always have values, which is logically fine. Unfortunately when...

Hi I would like to use a VLOOKUP referring to a table as follows; =VLOOKUP($D$12,TABLE1,TABLE1[HOLIDAY],FALSE) instead of =VLOOKUP($D$12,TABLE1,2,FALSE) I am not clear if this is doable without additional formulas, or with which formulas to use if more are needed. Thanks Sergio

Hi I am trying to summarize costs from a transactions table into a report by the group I have assigned to payees in a reference table. To get the correct value I would read the transactions table, take the payee, look it up in the reference table that shows the payee and the group it is...

Hi I am trying to determine how I can use the name of a table in a formula where I determine the name of a table depending on a lookup value. This is what I mean: I have two tables in a worksheet; table t_One and table t_Two. I want the total for a column in the table but I want to determine...

Hi I have a table, (tbl1), with columns "trans" and "amt" (simple example). I have a separate table, (tbl2), of possible transactions that can be used in the "trans" column of (tbl1). (tbl2) has only 1 column. From (tbl2), I created a defined name, (lst1), referring to the single column of...

Hi Here is what I am trying to do. I have a reference table. The table has three columns; "Symbol", "Security" and "Description". The value in "Description" is "Symbol" and "Security" combined. Here is an example: Symbol Security Description AAPL Apple AAPL-Apple BBRY...

Hi Having a bit of a problem finding something that is already written, so here is my question. I have a table (the new functionality) and I am using that to generate a validation list. I would then like to select related data from the same table, based on the selection via the validation...