Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 09-05-2016, 07:58 AM
jeffreybrown jeffreybrown is offline If=Then from one column cells to next column equivalent cells Windows Vista If=Then from one column cells to next column equivalent cells Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

Hi Ruth,

It sounds like you are looking for a Vlookup type scenario...

http://www.contextures.com/xlFunctions02.html

If you select Smith in C5 you want the address for Smith to automatically show up in D5?

If so, create the lookup table and then put the Vlookup in D5 and copy down as far as required.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
If=Then from one column cells to next column equivalent cells How to obtain a column total using only specific cells Jo Freeman Excel 3 03-20-2015 06:18 AM
Return Sum value of one column from cells not blank in another column zulugandalf Excel 3 08-14-2014 03:37 AM
Summing Non Contiguous Cells in a Row or Column Joe Ottenhof Excel 4 12-19-2012 04:13 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:15 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft