Countinuation of Formulae in new array

  • Thread starter Thread starter Gunjani
  • Start date Start date
G

Gunjani

Hi
I am using this formula VLOOKUP($B$1,'Team
A'!$A$18:$IV$45,MATCH($B5,'Team A'!$18:$18,0),0)

The Array starts from A18

As you realise due to Excel limitation (!) the array only goes as far
as Column IV; I wish to continue the Table array ( starting from a
new row rather than a new worksheet) say from Cell A50 to IV77 and then
continue again from A82 to IV109 and perhaps etc
Is it possible.

Please Note If it is to be done in Macro Please provide me a detailed
Idiot Guide
as I have NEVER PERFORMED/USED a Macro, and would not know where to
start.

Thx
Gunjani
 
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

Continuation of Formula in New Array 1
Array formulas/selecting data 2
Convert Array Formulas to Regular Formulas 4
Array formula SUMIF with 2D sum_range array 3
Re: Convert Array Formulas to Regular Formulas 0
Array formulas 3
Array formulas not working in Excel 2003. 2
Using SUM + INDEX in array formula 5

Back
Top