vlookup matching two columns

  • Thread starter Thread starter Christopher
  • Start date Start date
C

Christopher

Hello
i've been trying to use a vlookup in column a of workbook
1 from the following example. essentially if column b and
c from workbook 1 match column d and e of workbook 2 i
would like it to return column a of workbook 2 (if that
makes any sense at all!)
By any chance would somebody have any suggestions?


workbook 1
a b c
SP04 CANADA NOW
SP04 CANADA NOW
workbook 2
a b c d e
234 16-Oct-03 19-Nov-03 FA03 72 HOURS
123 12-Feb-04 31-Mar-03 SP04 72 HOURS
1234 18-Oct-01 21-Nov-01 FA01 AIR FARCE
 
Hi
in your workbook 1 in cel D1 enter the following array formula (entered
with CTRL+SHIFT+ENTER):
=INDEX('sheet2'!$A$1:$A$100,MATCH(1,('sheet2'!$D$1:$D$100=B1)*('sheet2'
!$E$1:$E$100=C1),0))

and copy down
 
hey thanks frank,
i'm having a little trouble deciphering though. its my
fault because the messages didnt' quite get posted as i
had originally pasted it. my apologies
in workbook 1 column A is blank(this is where i'm entering
the formula). colmn B and C should match column D and E
of workbook 2. when that happens i'm trying to get it to
return column A of workbook 2 into colmn A of workbook 1.
 
i've been applying it to the actual worksheet. jsut have
to change a few variables. i'm in toronto and have to run
for a train right now. won't be able to get back at it
until the morning. i appreciate your help immensely. if
i have problems would it be alright if i emailed you
tomorrow?

chris
 
Back
Top