Reference a whole column Excel 2007

[Shay A]

Hello,
Is it possible to reference a whole column in a function?
For example, in VLookup, my table array to be columns A:D, without specifying Rows.

Thanks,
Shay

 

[NARAYANK991]

Hi ,

Certainly you can.

Narayan

 

[Shteven]

Yes Shay you can. If your VLOOKUP looked like this:
=VLOOKUP(G1,A1:D10,4,FALSE)

You can easily change it to this:
=VLOOKUP(G1,A:D,4,FALSE)

 

[Somendra Misra]

Hi,

Or you can just create dynamic range with expanding rows in name manager and than use that in your function. That way your calculation speed will not slow down.

Regards,