Naming A Table Array in Vlookup

  • Thread starter Thread starter hhhh
  • Start date Start date
H

hhhh

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA userform Vlookup Excel 1
EXCEL - IF(IFERROR(VLOOKUP question 0
Array VLOOKUP lookup_Value does not increment 3
Vlookup error 1
Vlookup error 5
Array VLOOKUPs take 6 times longer than worksheet range VLOOKUPs 2
Vlookup result in a message box 10
Array takes 6x longer to process VLOOKUP than worksheet table does 3

Back
Top