Hello. I am having some issues with the following formula. It comes up with #VALUE.
=INDEX(ETN:AAPL!B5,MATCH(TRUE,EXACT(ETN:AAPL!B2,$C$2),0))
The gist of what I am trying to do:
If C2 on the first spreadsheet is equal to B2 of another spreadsheet, return the value in B5 of that sheet.
C2 would consist of text, B2 would consist of text, and it would be a numeric value in B5.
Thanks in advance.
=INDEX(ETN:AAPL!B5,MATCH(TRUE,EXACT(ETN:AAPL!B2,$C$2),0))
The gist of what I am trying to do:
If C2 on the first spreadsheet is equal to B2 of another spreadsheet, return the value in B5 of that sheet.
C2 would consist of text, B2 would consist of text, and it would be a numeric value in B5.
Thanks in advance.