Using Index to search case sensitive data

[dokouk]

I need some help with a similar situation but this time I need to look up within an array.

This is the data from my main spreadsheet.

Account	Account Id	Account Id	ID (18-Digit)	Sector	Industry
xxx PLC	0014L00000CLxzXQAT	0014L00000CLxzX	a084L000006tN3VQAU	Real Estate	Real Estate Management & Development

I have Account ID from 3rd cell stored in another spreadsheet and I want to return the details in column 6 ie steel

Sedol	Account Name	Account ID	ISIN	Country	Sector	Industry
xxxxxxx	xxxxxxx	0014L00000CLzLk		Australia	STEEL

I tried to use a variation based on =INDEX(Data!N:N,MATCH(TRUE,EXACT(F2,Data!N:N),0)) but this doesn't take into account arrays? Can you help?

 

[jkpieterse]

You could also use this:

=FILTER(Data!N:N,EXACT(F2,Data!N:N))

I advise not to use entire column references and to convert your range to a table and point to the table column.
"If it looks like a table, format as table"

 

[dokouk]

You could also use this:

=FILTER(Data!N:N,EXACT(F2,Data!N:N))

I advise not to use entire column references and to convert your range to a table and point to the table column.
"If it looks like a table, format as table"

Sorry I posted the wrong formula; the formula I'm using is =INDEX('account sedol etc.csv'!$C:$F,MATCH(TRUE,EXACT(C2,'account sedol etc.csv'!$C:$F),4))

Also I have about several thousand lines to apply this formula to.

 

[jkpieterse]

Probably better to start using power query to:
- Pull in that CSV
- Join the resulting table with the other table using an exact match