VLOOKUP Range

  • Thread starter Thread starter BJ
  • Start date Start date
B

BJ

Is it possible to use VLOOKUP or HLOOKUP on noncontiguous ranges? For
instance range A1:D2,H1:K2? I've tried it using the cell references and by
naming the range and can't get it work. Just curious if it is possible or
not ...

Thanks.
 
You could use

=vlookup(x99,a1:k2,###,false)

and just make sure you don't return a value from columns E:G
 
That's what I ended up doing Dave - thanks though. I was just curious if
there was a way around the contiguous range requirement ... always looking
for nuances ...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nesting Lookup Functions 4
Linked Named Ranges 2
Using Value of a Cell in the Range Reference in VLOOKUP 1
range label works in VLOOKUP except if refenced in another cell 3
Hlookup & Vlookup 2
Refer to a named range indirectly 2
VLOOKUP with a Named Range argument 1
a data validation list that contains a list of named ranges - not alist from a named range 1

Back
Top