Hi Joe
You're welcome.
Type "Relative & Absolute' in Excel Help, this will bring up all the
information you need when you copy formulas.
Regards
John
"Joe" wrote in message
...
"John" wrote:

Hi Joe
Try it this way:
=VLOOKUP(A3,AA100:Ab309,2,FALSE)
HTH
John


John,

That did the trick. However, if I copy/paste to all my cells, I noticed
Excel had a tendency to update the entire formula. For example €“ instead of€¦

=VLOOKUP(A3,AA100:AB309,2,FALSE)
=VLOOKUP(A4,AA100:AB309,2,FALSE)
=VLOOKUP(A5,AA100:AB309,2,FALSE)
=VLOOKUP(A6,AA100:AB309,2,FALSE) etc;

I got€¦

=VLOOKUP(A3,AA100:AB309,2,FALSE)
=VLOOKUP(A4,AA101:AB310,2,FALSE)
=VLOOKUP(A5,AA102:AB311,2,FALSE)
=VLOOKUP(A6,AA103:AB312,2,FALSE)

It was no big deal to correct. I just thought it was interesting Excel
updated everything.

Again, thank you for your help and expertise.

Joe