Validation Against another Cell
=VLOOKUP(B41,A1:B10,2,FALSE)
but this is not data validation, this is a lookup job!
Regards,
Stefi
€˛Stacy C€¯ ezt Ć*rta:
Here is my setup:
B41 is a cell where the user enters a date (current or otherwise).
I have a range of values from B1:B10, and the dates in A1:A10.
What is the formula that I would use that would automatically pull the
correct data from the cells in B1:B10, based upon the corresponding date in
A1:A10, after a person enters the desired date into B41?
|