Using Vlookup w/ Multiple Lookup values

[Angela Markou]

Hi -

I was wondering if anyone knew of a formula or of code I
can write in VBA that would allow me to use a Vlookup
formula (or similar) to use multiple lookup criterias in
order to query data from different locations.

Any suggestions would be greatly appreciated!

Angela

 

[Alan Beban]

If I understand you correctly, and if hardcoding works for you, you
might try something like

=VLOOKUP({value1,value2}, dataRange, 2, False)

Alan Beban

 

[Frank Kabel]

Hi Angela
can you provide some more details:
- what kind of lookup criteria
- what are your different locations
- is VBA required or is a worksheet function based solution also
feasible
- provide some examples (plain text - no attachments please)

 

[Jafoembie]

Your Vlookup query

Come on Angela

Its not rocket science is it? Very easy!

Jason M