Forum Discussion
#VALUE! error
Since you have already posted it, and I've already looked at it, and have the following observation and solution)
Some of your tab names have a space after the name. (Downing is one; the tab itself said "Downing " and though your eyes and mine see that as the same as "Downing" Excel sees the space and sees it as different. Therefore the error message.
That said, I created a different formula to pull the dates in cell F39 from each of the individual tabs. It uses INDIRECT and the last name pulled from column A. You do NOT need to be copying and pasting every cell.
=INDIRECT(RIGHT(A2,LEN(A2)-FIND(" ",A2))&"!F39")
It would help if you created the list in column A differently. Surely you have a list of all employee names somewhere. As it is, you're pulling those too from the separate employee tabs. Not at all an efficient way to do it.
I'm returning a totally anonymous version with only one employee--newly hired--by the name of Darth Vader. You can copy the formula, though to your original sheet. If you still have difficulty, by all means, come back, but post a copy of your workbook with anonymous names; Star Wars characters usually make it interesting.
