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/307182-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

All times are GMT +1. The time now is 05:18 PM.