Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concentate in VLOOKUP
Hi all, I'm wondering if anyone can suggest a means of concentating three columns whilst using VLOOKUP. I basically have a spreadsheet that has one column for address, but the document where the VLOOKUP is looking has three seperate columns for the address (address 1, address 2, postcode). Any help appreciated, TIA, SamuelT -- SamuelT ------------------------------------------------------------------------ SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501 View this thread: http://www.excelforum.com/showthread...hreadid=562370 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concentate in VLOOKUP
I feel you should concatenate all the three columns into one column and lookup. -- blissworks ------------------------------------------------------------------------ blissworks's Profile: http://www.excelforum.com/member.php...o&userid=36156 View this thread: http://www.excelforum.com/showthread...hreadid=562370 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concentate in VLOOKUP
Thank Blissworks - that's a very simple solution! -- SamuelT ------------------------------------------------------------------------ SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501 View this thread: http://www.excelforum.com/showthread...hreadid=562370 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concentate in VLOOKUP
=INDEX(O1:O10,MATCH(A1,L1:L10&" "&M1:M10&" "&N1:N10,0))
which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. you may have to play about with the separators, I have used a space -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "SamuelT" wrote in message ... Hi all, I'm wondering if anyone can suggest a means of concentating three columns whilst using VLOOKUP. I basically have a spreadsheet that has one column for address, but the document where the VLOOKUP is looking has three seperate columns for the address (address 1, address 2, postcode). Any help appreciated, TIA, SamuelT -- SamuelT ------------------------------------------------------------------------ SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501 View this thread: http://www.excelforum.com/showthread...hreadid=562370 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup a Vlookup | Excel Worksheet Functions | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions |