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?

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


"FARAZ QURESHI" wrote in message
...
| 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?

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


"FARAZ QURESHI" wrote in message
...
| 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?

<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


"FARAZ QURESHI" wrote in message
...
| 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
|
|
| "FARAZ QURESHI" wrote in message
| ...
| | 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?
|
|
|