MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Automatically copying data from cells with same values

Posted by Chris on February 24, 2000 9:43 AM

I am trying to figure out a way to get Excel to automatically copy data from multiple cells (phone number, address, etc..), when I type in a value that matches cells (name and company) from above in my spreadsheet. Does any body have any ideas?


Posted by Chris on February 24, 2000 11:47 AM


It sounds like what you're after is the vlookup formula. Check out the help menu for more info.