VLOOKUP 4 MULTIPLE ARRAYS?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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


| 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.
 
<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?
| >
| >
| >
 
Back
Top