When i use VLOOKUP function i have to select a range of cells in 2 different columns (C and D or any else).
The problem is don’t work the shortcut (ctrl+shift+end) from C1:D3000 and must use muse with drag or find the number of end cell.
Is this only way or exist different shortcuts into a function?
Hello @dimzev,
So far as i know, VLOOKUP() does not require any cells to be selected in the GUI. The lookup range can be specfied as a string address ( “C1:D3000” ).
I’d recommend OP to use named ranges, which allows to change the range in one place
if no need to select you must find and note the last line-cell and write as string .
If you try you see we can select with mouse and drag but for many lines is hard…