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?