'Why does my INDEX MATCH formula not work on Google Sheets?
So I am having some issues with extracting the correct data to the "Battery Logs" Sheet from "FC" Sheet. I am trying to copy the data from the column range C2:D in "FC" Sheet to column range D2:E in "Battery Logs" Sheet under certain requirements.
The requirements are that the "Battery Number" and the "Date of Charging" under the "Battery Logs" Sheet should match with the "Battery Number" and the "Date" under the "FC" Sheet.
I tried using this INDEX MATCH formula:
=arrayformula(INDEX(FC!C2:D, MATCH( (A2=FC!A:A) * (B2=FC!B:B), 0)))
And the end result in the Battery Logs does not even match the requirements.
The formula is in D2:E2 under the "Battery Logs".
For the desired output, I would want D2:E in "Battery Logs" to follow and match with C2:D in "FC" to match the said requirements.
Any idea how I could get this correct data output displayed in my “Battery Logs” sheet?
Will really appreciate if any kind souls could help me out with this thanks!
The link to my Google Sheets is here
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|