Index Match With Tables Not Working

[DeaninGA]

All,

I have an issue with Index and match In tables Returning an N/A.
Heres the Formula =INDEX(Table13[#All],MATCH([@[Frame Only]],Table13[Window Size],0),MATCH([@[SDL Light]],Table13[#All],0))

Table 13 is where my price table is I want to pull it in based on 2 values Frame Only and SDL Light ( both Named fields on my main table.)

Thank you in advance
Dean

 

[Fluff]

As the headers of a table are text, you need to use

=INDEX(Table13,XMATCH([@[Frame Only]],Table13[Window Size],0),XMATCH([@[SDL Light]]&"",Table13[#Headers],0))

 

[DeaninGA]

As the headers of a table are text, you need to use

=INDEX(Table13,XMATCH([@[Frame Only]],Table13[Window Size],0),XMATCH([@[SDL Light]]&"",Table13[#Headers],0))

Perfect.. Thanks for the lesson and the solve....

 

[Fluff]

You're welcome & thanks for the feedback.