Offset based of list and multiple tables

**colin5392** · 01-22-2019, 08:14 AM

See attached

Trying to link an offset table to a drop-down list (L2 within TREND Analysis worksheet) with data stored in multiple tables (DataSet) - can you help in linking the drop-down option to the correct table and for the offset (within TREND Analysis) to update accordingly?

Thanks in advance

Colin

**Bo_Ry** · 01-22-2019, 08:37 AM

Please try at L6 drag across and down

=INDEX(DataSet!$C$3:$AO$30,$K6,MATCH($L$2,DataSet!$C$1:$AO$1,)+COLUMNS($L6:L6))

**colin5392** · 01-22-2019, 08:41 AM

Perfect - thank you

Offset based of list and multiple tables

LinkBack

Thread Tools

Rate This Thread

Display

Offset based of list and multiple tables

Re: Offset based of list and multiple tables

Re: Offset based of list and multiple tables

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Insert rows based on cell value for list in column F with numbering offset by one

Restrict data validation list based on criteria from multiple tables

[SOLVED] Merge multiple sheets data into 1 sheet based on multiple criteria (List Based)

Dynamic dependent Validation List based in multiple tables and formulas

Filter multiple pivot tables based on same cell value (OLAP based)

[SOLVED] Multiple drop down list that automatically update using offset and named ranges

Bookmarks

Bookmarks

Posting Permissions