MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Amar on April 02, 2001 12:15 AM

I need to retrieve data from a range in a different sheet, and input that data into another sheet. how do I do this?

Posted by Rick M on April 02, 2001 5:00 AM

Use the VLOOKUP function. Hit the = button next to the formula bar and select Vlookup - follow the wizard.

Posted by Mark W. on April 02, 2001 12:52 PM

You could also use an Advanced AutoFilter.