ExcelBanter - Naming A Table Array in Vlookup

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Naming A Table Array in Vlookup (https://www.excelbanter.com/excel-programming/307181-naming-table-array-vlookup.html)

hhhh

Naming A Table Array in Vlookup

Hi,

I want to name a Table array for VLookUp ie, I have an excel sheet
with =IF(C10="","",VLOOKUP(C57,job,2,FALSE)) job = I18:O29

So my question is how do I make a work represent a table array?

I want to know this to have more control over my formulas as i cut and
paste

Thanks
hhhh

Frank Kabel

Naming A Table Array in Vlookup

Hi
use 'Insert - Name - Define' for this

--
Regards
Frank Kabel
Frankfurt, Germany

"hhhh" schrieb im Newsbeitrag
om...
Hi,

I want to name a Table array for VLookUp ie, I have an excel sheet
with =IF(C10="","",VLOOKUP(C57,job,2,FALSE)) job = I18:O29

So my question is how do I make a work represent a table array?

I want to know this to have more control over my formulas as i cut
and
paste

Thanks
hhhh

All times are GMT +1. The time now is 07:07 AM.