vlookup in two sheets with two columns

[niladri20052006]

Hi All,

I am new comer in this forum. Hope this will great learning journey for me. I am not whip at Excel but want to learn a lot.

I have a problem. I have a work book containing two sheets. In first sheet I have three Columns as Company Name, Email ID and State.

In the second sheet I have the same column with same field. But here is some unmatched data.

I want to pick those companies that will be the same company Name and Email ID from the first sheet.


How will I do that? I am using using Vlookup formula one by one but i want to do it at a time with Vlookup formula or other?


Please help!!

 

[venkat1926]

suppose your sheet 1 is like this (A1 to c5)

company email state
a q z
s w x
d e c
f r v

<table width="64" border="0" cellpadding="0" cellspacing="0"><tbody><tr style="height:12.75pt" height="17"><td style="height:12.75pt;width:48pt" width="64" height="17">
</td></tr><tr style="height:12.75pt" height="17"><td style="height:12.75pt" height="17">
</td></tr></tbody></table>sheet 2 like this (A1 to C2)

name email state
d

in B2 copy paste this formula

=VLOOKUP($A2,Sheet1!$A$1:$C$100,COLUMN(B$1),0)
copy B2 to C2 and also down if more data is available in column A of sheet 2


read on "vlookup" in excel help