![]() |
#2
|
|||
|
|||
![]()
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. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
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 |