Correction:
=VLOOKUP($A12,Report!$A$12:$Q$37,Columns($A:B))
--
Regards,
RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------
=VLOOKUP($A12,Report!$A$12:$Q$37,Columns($1:2))
--
HTH,
RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================
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)
