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