Timeline for Matching values in a row in excel
Current License: CC BY-SA 4.0
2 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 10, 2021 at 11:26 | comment | added | Gale | The problem with that formula is that I don't know what row I'm looking at for the I value on the reference sheet. I need to find a row in my reference sheet where the value in column A matches the reference cell and the value in column I matches the specified value, but I don't know what row that is for either value. So I don't know that it's I6 (for example). That's why my formula doesn't work, because ColumnI needs to be a fixed reference and it isn't. | |
| Jul 9, 2021 at 9:13 | history | answered | Viki Ji | CC BY-SA 4.0 |