Forum Discussion
Excel formatting in a mixed cell
Hello, I'm trying to set up a cell to display "on mm/dd/yy", where the date is pulled from another cell via an index and match function. The cell formula is ="on "&INDEX(...)). However, instead o...
Thank you. That works.
I just need to figure out how to merge it with the Index-Match formula, so I don;t need to point to an alternate cell for the date.
Thanks, again,
JQuinn
So long as your spreadsheet doesn't contain private or confidential info, you can post it here so we can work with the actual situation rather than having to reconstruct it from your description.
I think that "all you'd need to do" is nest the INDEX/MATCH function within that TEXT function, assuming that what the INDEX/MATCH is doing is getting the date in question. It's hard to be certain without seeing more directly what you're working with.