=VLOOKUP($A12,Report!$A$12:$Q$37,Columns($1:2))
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"Sean" wrote in message
...
How could I adjust the formula below, so that I can drag to columns
A:Q without having to change the last digit for each column?

=VLOOKUP($A12,Report!$A$12:$Q$37,2)