| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel to recog a surname, + paste address associated in new cell
I want a formula for excel to recognise 2 surnames, then paste the associated
address(the cell next to the first surname) into the formula cell. eg. 1st surname in A1, address in B1. second surname and function in another sheet. i.e if both surnames match, paste address into function cell. Any idea's? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel to recog a surname, + paste address associated in new cell
Have a look at vlookup: http://contextures.com/xlFunctions02.html You may work solve the problem yourself after reading it, and it's not wasted time. -- John James ------------------------------------------------------------------------ John James's Profile: http://www.excelforum.com/member.php...o&userid=32690 View this thread: http://www.excelforum.com/showthread...hreadid=532147 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| resetting last cell | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
| ?? Extra blank lines in 'address' cell after exporting to Excel | Excel Discussion (Misc queries) | |||
| Excel change SUM references if you cut & paste the first cell in SUM... | Excel Discussion (Misc queries) | |||
Linear Mode
