vlookup


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.