How to apply vlookup formula dynamically to a worksheet

  • Thread starter Thread starter vardhan
  • Start date Start date
V

vardhan

I want to apply vlookup formula to Range of cells, but data may not be static.
Help me to how to approach that...
 
Hi,

What will change? Will the lookup value always be in the same column and
value brought back be in the same column, so just the "length" of the data
will be changing?

What is the dynamic part of the lookup?
 
I usually define a range and use the range name as the source dat for the
pivot. Here is an example :

=OFFSET(Calendar!$A$1,0,0,MAX(2,COUNTA(Calendar!$A:$A)),4)

This is the defination of a range called CALENDAR which uses the a dynamic
range on a worksheet called calendar whcih stretches from A1 to Ax where x is
the last row in column A.

Hope this helps
 
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

Vlookup result in a message box 10
Defining a dynamic table_array for vlookup 9
VBA userform Vlookup Excel 1
VLOOKUP 2
Code works on sheet but not from code-to-sheet 2
Dynamic col_index_num in VLOOKUP? 5
Array VLOOKUP lookup_Value does not increment 3
Excel VBA 1

Back
Top