BMiller828✭

Paul, worked instantly. I am sure I was asking the wrong questions. Thanks for all your help!

When user submits a form, they check one or multiple boxes on this sheet. I then need the date to populate into these boxes on the master sheet. Ignore the data that is there as its not accurate. As you can see, I have the formula in the FLIGHT REVIEW column. Its returning a blank cell.

I am. The box is called "Flight Review". The checkboxes are located in a column titled training on another sheet. When that box is checked on the form / sheet, I want the date to populate into this cell in the column titled "flight review" on my master sheet. There are multiple boxes that could be checked with different…

I think I copy. Like this. =IF(INDEX({TRAINING}, MATCH("FLIGHT REVIEW", {TRAINING}, 0)) = 1, INDEX({DATE}, MATCH(PILOT@row, {PILOT}, 0))) Still getting a blank cell.

I'm guessing you mean like this. I changed the 1 to a 0. I thought that by telling it to MATCH "flight review" it would look for that exact match? Tried this. =IF(INDEX({TRAINING}, MATCH(FLIGHT REVIEW@row, {TRAINING})) = 0, INDEX({DATE}, MATCH(PILOT@row, {PILOT}, 0))) This gives me an unparseable error. Just changing the 1…

Paul I think I'm gonna owe you a beer or pizza or something..... The formula is working as I am now getting a blank box. I assume, I still have something missing / wrong but not sure what? =IF(INDEX({TRAINING}, MATCH("FLIGHT REVIEW", {TRAINING})) = 1, INDEX({DATE}, MATCH(PILOT@row, {PILOT}, 0)))

This kinda worked as it at least returned the checked box. I still need it to be a date though..... =INDEX({TRAINING}, MATCH("FLIGHT REVIEW", {TRAINING}, 0)) When I try to nest with the IF, still getting errors? =IF(INDEX({TRAINING}, MATCH("FLIGHT REVIEW", {TRAINING}, 0, INDEX({DATE}, MATCH(PILOT@row, {PILOT}, 0)))))

好的。这样我就可以得到一个“不匹配”的错误智慧h - =INDEX({TRAINING}, MATCH(PILOT@row, {TRAINING}, 0)) I can get the date to populate with - =INDEX({DATE}, MATCH(PILOT@row, {PILOT}, 0)) I am having trouble understanding how to index / match the check box? If I index the training column, how to I make the formula match the box that…

Thank you for your help on this. I'm definitely newer to this platform and still learning. =IF(INDEX({TRAINING}, MATCH("FLIGHT REVIEW", INDEX({DATE}, MATCH(PILOT@row, {PILOT}, 0))))) Not sure if this is what you mean? Still getting an "incorrect argument" error. I think the issue is that the Training column has multiple…

Still stuck on this one. Getting an invalid data type error. Using =IF({TRAINING}, ="IIMC / INSTRUMENT", INDEX({DATE}, MATCH(PILOT@row, {PILOT}, 0)))