<nor can I create a new array everytime>
Does that mean your formula has to change everytime? How will it know when to change to what?
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
| Can't manipulate with the master data nor can I create a new array everytime,
| somewhere in a new book.
|
| "Niek Otten" wrote:
|
| > I would create a new array which contains just the values you need, using simple =A1 like formulas, and use that to look up
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| >
| > | > | Any idea how to devise a formula as VLOOKUP to lookup into multiple arrays?
| > | Suppose, I want to skip rows 11:11, 15:15, 20:20 and 30:32 from the range
| > | A1:C50 for looking up a value only in the remaining records?
| >
| >
| >