VLOOKUP QUESTIONS

  • Thread starter Thread starter russell
  • Start date Start date
R

russell

HI all ,

I have formula below :

=VLOOKUP(ranking!B4,contractorData!row_index_wt,5)

The formula is in the another worksheets.

The contractorData is another worksheet in same excel file.The
"row_index_wt" is a define name. My problem is that when i added new
column in "row_index_wt" the formula will be wrong because of value of
"5" in the formula. How to dynamically change the last value in the
VLOOKUP formula when new column added ?

Any ideas ??

Thanks.
 
What is the current range to which contractorData!row_index_wt refers to?
Does this include the row with labels if you have such a row? Care to state
which row houses the labels?
 
Back
Top