Ask Your Question

shortcuts keys into a function

asked 2017-09-09 18:08:48 +0200

dimzev gravatar image

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?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-09-09 20:29:30 +0200

librebel gravatar image

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" ).


edit flag offensive delete link more


I'd recommend OP to use named ranges, which allows to change the range in one place

Mike Kaganski gravatar imageMike Kaganski ( 2017-09-09 21:21:01 +0200 )edit

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...

dimzev gravatar imagedimzev ( 2017-09-10 16:47:58 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-09-09 18:08:48 +0200

Seen: 140 times

Last updated: Sep 09 '17