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

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

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

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