How do you set up your formula to account for additional records automatically?
For example, my current formula might read: =VLOOKUP(A16,A1:D8,2,FALSE)
But now I want to add a record to the search area...
What must I do to this formula to take additional records into account automatically?
Thanks-
For example, my current formula might read: =VLOOKUP(A16,A1:D8,2,FALSE)
But now I want to add a record to the search area...
What must I do to this formula to take additional records into account automatically?
Thanks-