Vlookup and copy entire row

[dingdang]

Hi,


Need vlookup or if any other formula to get entire row from 2 input data which match with data and copy entire row.

attached file for your ref. data input in A15 and B15 should match with data range A1:H11 and if match then required entire row copy to D15


https://dl.dropbox.com/u/66400357/dummy.xlsx

 

[Faseeh]

Hi dingdan,


See this file:


http://dl.dropbox.com/u/60644346/dummy.xlsx


Regards,

Faseeh

 

[Debraj]

Hi Faseeh,

As-Salamu Alaykum


Just passing from here..

You missed a condition..

data input in A15 and B15 should match

Can you please allow me to add this condition also in the formula.. by using below formula..

=IF(VLOOKUP($A15,$E$1:$F$11,2,0)=$B15,INDEX(A$1:A$11,MATCH($A15,$E$1:$E$11,0)),"Not Matched")

BTW, is your office's internet problem has been solved or not..


Khuda Hafiz,

Deb.