Hello,
I'm facing a problem I don't understand,
I've a huge table (Table11):
K2 contains the date I want to search for.
The cell [@[Planned_Start]]) contains the ID.
I want to get the value (date) from column "Planned Start Date".
Here is the formula I used:
I'm using a german version, that explains the ; instead of , .
I got the route how to create that formula from here:
www.mrexcel.com
When I set the filter by hand, I got only one value/line displayed, but Excel is shown #VALUE The column index number is too small. Specify a number greater than or equal to 1.
I don't know what I made wrong in here.
I'm facing a problem I don't understand,
I've a huge table (Table11):
| Date | ID | Planned Start Date | Planned End Date | ... other columns... |
K2 contains the date I want to search for.
The cell [@[Planned_Start]]) contains the ID.
I want to get the value (date) from column "Planned Start Date".
Here is the formula I used:
VBA Code:
=VLOOKUP(2;1/(Table11[Date]=$K$2)/(Table11[ID]=[@[Planned_Start]]);Table11[[Planned Start Date]:[Planned Start Date]])I'm using a german version, that explains the ; instead of , .
I got the route how to create that formula from here:
Filtering with "SUMPRODUCT()" raises "a value used in the formula is of the wrong data type"
Hello together, I'm stuck at a "SUMPRODUCT()" formula. I want to use that formula as filter (VLOOKUP()) for several criteria. But stuck at a point I don't understand. My sheet has a table with > 3 columns. Column contains type empty rows A timestamp string no B item-id integer no C...
When I set the filter by hand, I got only one value/line displayed, but Excel is shown #VALUE The column index number is too small. Specify a number greater than or equal to 1.
I don't know what I made wrong in here.
