Recent content by scecchin

Thanks Debaser. Was hoping I was missing something since other formula actions do work there, but does not seem to be the case here. Thanks for the feedback

Thanks for the feedback, p45cal. Agreed, this can be managed that way. Was just trying to push the envelope and avoid that intermediary step, but I acknowledge this will work

Thank you for your feedback, Michael, much appreciated. I was looking for a solution where I did not need to generate the sorted and unique list (C42), and then reference that. I am trying to build this directly from the structured reference table, something like the...

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 Somendra A deceptively simple solution that works well.o_O Thank you for your help. Sergio

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

Thanks Mike, that works well, as well. This leaves me with a few options although each option still obliges multiple functions. Perhaps one day Microsoft with bring an enhancement where a formula like VLOOKUP would be smart enough to recognize the table column name and use the its column...

Hi Perhaps a little confusion here. I do want to look up $D$12 in the first column of the table and I want to retrieve the related value from the column [Holiday]. While this column is the second column in the table, if I enter the number 2, and then later insert a column, it breaks the...

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 Narayan Thank you for the quick reply. I greatly appreciate it. 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...

Thank you Narayan I thought that INDIRECT() was what I needed to use but I had the syntax wrong. Actually what I did with your help is the following: =SUM(INDIRECT(VLOOKUP(J8,t_TableNames,2,FALSE)&"[[#Totals],[Amt]]")) This will allow me to select a unique value and then have related data...

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

Both methods; Ctrl+Shift+Enter to create an array formula of the original attempt, and using SUMPRODUCT instead of SUM, worked. Thank you for your help. Sergio

Hi I have created a small example file of the data above. The formula is there once as it works and once it does not, for each of two lists Thanks Sergio