Index Match in different sheets and different tables

**BassemCh** · 05-13-2021, 12:44 PM

Hello

I wish someone can help solving this issue, and I am attaching an example workbook here.

I have a workbook with 2 sheets, and 1 table in each one, I need to get the value of one cell in shee2, if all cells in the row matches with the cells in the source table in sheet1.

Thank you for helping, if any has a solution.

**JohnTopley** · 05-13-2021, 01:26 PM

A simple solution is to create a "helper" column concatenate the fields to make a "key"

=[@Program]&[@Course]&[@[Course ID]]&[@C]

in sheet2

=INDEX(tbl_source[Start date],MATCH([Program]&[Course]&[@[Course ID]]&[C],tbl_source[Column1],0))

**BassemCh** · 05-13-2021, 02:01 PM

Thank you that works

**BassemCh** · 05-26-2021, 06:12 PM

After testing, seems this formula is not working and I'm having lots of #N/A in the cells. Any Idea why I'm having #N/A?

Thanks again.

Index Match in different sheets and different tables

LinkBack

Thread Tools

Rate This Thread

Display

Index Match in different sheets and different tables

Re: Index Match in different sheets and different tables

Re: Index Match in different sheets and different tables

Re: Index Match in different sheets and different tables

Thread Information

Users Browsing this Thread

Similar Threads

INDEX MATCH Over Seventeen Tables

[SOLVED] Index Match Between Tables

[SOLVED] OFFSET INDEX MATCH MATCH with multple tables

[SOLVED] INDEX MATCH MATCH with multiple layered tables

[SOLVED] INDEX/MATCH and SUMIFS with Tables

Difference between two tables using index match?

Index Match Match Formula DOESN'T WORK WITH TABLES/TABLE NAMES ??

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions