=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