Excell multiple lookup values

  • Thread starter Thread starter Dennis Barylski
  • Start date Start date
D

Dennis Barylski

Hello,
I am trying to vlookup data from one workbook to another, the problem
I'm having is I need to lookup data in 2 columns and return the
appropriate infomation from another column.
Something like this:

A B C
1 47851/1 10 INFORMATION
2 47851/1 20 INFORMATION

I need to lookup the value's in A and B in one workbook and bring the
infromation from C over. The information in C is different for each
line.

Any help will be appreciated.
Thx,
Dennis
 
Hi Dennis,

You can concatenate Col. A & B in another Col.say Col. D
i.e. at row 2 of Col. D, you have to give this command :
a2&b2. Then, copy this formula to entire range, and do a
vlookup using this new column to get the info. Please do
not forget to copy your Col. C after new Col. D, as
vlookup can only look the next Column onwards and not
backward.

Thanks,

Manish
 
If I understand what you're looking for, with your list on sheet1, you wish
to enter 2 lookup values in sheet2 and get matching data returned from
Column C of sheet1.

Assume list on sheet1 is A1:C5,
Assume lookup value for sheet1 ColA is entered in sheet2, D1,
Assume lookup value for sheet1 ColB is entered in sheet2, E1,



=INDEX(Sheet1!$C$1:$C$5,MATCH(Sheet2!D1&Sheet2!E1,Sheet1!$A$1:$A$5&Sheet1!$B
$1:$B$5,0))

This must be array entered, CSE (ctrl+shift+enter) and can drag down to copy
as needed.
Proper entry will enclose the formula in curly brackets.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



Hello,
I am trying to vlookup data from one workbook to another, the problem
I'm having is I need to lookup data in 2 columns and return the
appropriate infomation from another column.
Something like this:

A B C
1 47851/1 10 INFORMATION
2 47851/1 20 INFORMATION

I need to lookup the value's in A and B in one workbook and bring the
infromation from C over. The information in C is different for each
line.

Any help will be appreciated.
Thx,
Dennis
 
Back
Top