Re: VLOOKUP 4 MULTIPLE ARRAYS?

Tech-Archive recommends: Fix windows errors by optimizing your registry

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" <FARAZQURESHI@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:09E03A55-26E9-4D8D-A828-1F8D8BF96ADD@xxxxxxxxxxxxxxxx
| 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?


.

Relevant Pages

  • Re: C++ sucks for games
    ... >> Kind regards, ... > in arrays, then you can just allocate a big array of that type and build ... > setup (what would naturally be an array of structs, ... (defun set-int (i j) ...
    (comp.lang.lisp)
  • Re: evidence for the existence of the ether
    ... > jahn wrote: ... >> Mathematically a field is just an array of imaginary points. ... Just because you subscribe to a set of physical laws that assigns ... Kind regards, ...
    (sci.physics.relativity)
  • Re: VLookup problems...
    ... What does "go to the next array for the lookup" mean; what do you actually do if you do that? ... Kind regards, ... Microsoft MVP - Excel ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Splat array with 1 value in Ruby 1.9 vs Ruby 1.8
    ... this can be handled by generating code that checks the array ... But I am curious on this behavior of splat when the array contains ... I think that this is a bug in Ruby 1.9. ... Kind regards ...
    (comp.lang.ruby)
  • Re: Sending file as a parameter
    ... used two variables in the interface for uploading the file: ... the "array of byte". ... > Kind Regards, ...
    (microsoft.public.dotnet.framework.compactframework)