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?