Bob Bridges wrote:
While you're answering smartin's very relevant questions, allow me to point
out that the sample formula you typed out for us won't work. Even assumping
an extra bang ("!"), like this:

VLOOKUP(A2,Tab1!A2:B50,3)

...the third argument says to take a value from the third column, yet you
specified only a two-column table. In my version of Excel, at least, this
returns the #REF error.

Bob, Thanks for looking over my overlooking the obvious (^: