Forum Discussion
Excel: assistance with nested formula
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. The user to put an x in the correct cell in the Select Pay Date (F...
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.
So does it have to be numbers in the formula instead of x? Just curious for next time.
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).
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.