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.
- OMG!! Thank you so much I have been pulling my hair out and you did it in like two minutes.
