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), corresponding to the current pay date.
- Based on the specific cell in column F, I want a formula that pulls the correct date from want Check Date/Pay Day (G) and put it in E1 in short date format.
- Based on the specific cell in column F, I want a formula that pulls the correct date from want Period Start (I) and put it in B1 in short date format.
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!
5 Replies
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).
- OMG!! Thank you so much I have been pulling my hair out and you did it in like two minutes.
