Hello,
I now want to update a table based on 2 matching criteria in another table. I've been searching the web for help on using the index/match combination. The first example from one site in particular and the "non-array" example they use "seems" to be what I need, but I just get error messages. I thought the only problem was that I didn't have the same number of rows in one of the tables, but I did a test to at least "appear" to have the same row numbers but still got errors. Can someone help me fill the "chla" values from one table to the another as illustrated in the spreadsheet attached (screenshot of it below)?
Thanks!
IndexMatchChlaBottleExample2.png
Bookmarks