Hi,
Need vlookup or if any other formula/macro to get entire row from 2 input data which match with data in 2nd sheet and copy entire row.
attached file for your ref. data input in A3 and B3 should match with data in "main data" sheet and if match then required entire row copy to D3.
Pls help
https://dl.dropbox.com/u/66400357/test.xlsx