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?

Thanks,
Chris


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

Chris,

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

HTH,
Chris