If=Then from one column cells to next column equivalent cells

		Microsoft Office Forums > Microsoft Excel > Excel
If=Then from one column cells to next column equivalent cells

FAQ

Thread Tools

Display Modes

09-05-2016, 07:58 AM

jeffreybrown jeffreybrown is offline

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 about

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.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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.