Vlookup

[April]

I don't know how to do the two conditions vlookup.

For example, I need to compare Col.A & Col.B (sheet 1) match with Col.A &
Col.B (sheet2), and if they are then take the info on Col.C (sheet2) and
put in Col.D (sheet1).

I only know the simple vlookup such as:

=VLOOKUP(A5,sheet2!$A$2:$D$339,4,FALSE)

I would appreciate very much if someone would help me.

April

 

[Dave Peterson]

maybe:

=INDEX(Sheet2!$A$1:$A$444,MATCH(A1&CHAR(1)&B1,
Sheet2!$A$1:$A$444&CHAR(1)&Sheet2!$B1:$B$444,0))
(one cell)

But instead of just hitting enter, hit ctrl-shift-enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

(and adjust your range accordingly (I stopped at row 444).)

 

[Guest]

Dave,
In your lookup table you could create a column with the formula =A1&B1. Then you can use this column as your lookup column. In your lookup function you can use A1&B1 as the lookup value.

Good Luck,
Mark Graesser
(e-mail address removed)

----- Dave Peterson wrote: -----

maybe:

=INDEX(Sheet2!$A$1:$A$444,MATCH(A1&CHAR(1)&B1,
Sheet2!$A$1:$A$444&CHAR(1)&Sheet2!$B1:$B$444,0))
(one cell)

But instead of just hitting enter, hit ctrl-shift-enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

(and adjust your range accordingly (I stopped at row 444).)