Apr 08 2021 08:59 PM
Windows 10/EXCEL FOR MICROSOFT 365 MSO (16.0.13901.20148) 32-BIT
I have attached my file. Here's what I'm trying to make happen.
I've tried IF, COUNTIF, in conjunction with INDEX and MATCH and I cannot seem to figure it out. I feel like this is possible. I would really appreciate some assistance in figuring out the proper formula. Thank you!
Apr 08 2021 09:06 PM - edited Apr 08 2021 09:12 PM
@EDDRENB Please see attached. Used INDEX/MATCH in B1 and E1. Is that what you meant?
Edit: Noticed you had Data Validation in F, accepting only "1", rather than "x". Changed the formulae accordingly. New file uploaded below.
Apr 08 2021 09:19 PM
Apr 08 2021 09:20 PM
Apr 08 2021 09:38 PM - edited Apr 09 2021 08:17 AM
@EDDRENB Well, the data validation is set-up to accept only one entry in F4:F19 and then only "1" (i.e. the number 1 as a text) or "" (i.e. a blank).
Apr 09 2021 08:07 AM
@Riny_van_Eekelen Got it! I originally had it as x but then i thought maybe it wasn't working because it needed to be numeric. Thank you so much again.