Concentate in VLOOKUP

S

SamuelT

Hi all,

I'm wondering if anyone can suggest a means of concentating thre
columns whilst using VLOOKUP. I basically have a spreadsheet that ha
one column for address, but the document where the VLOOKUP is lookin
has three seperate columns for the address (address 1, address 2
postcode).

Any help appreciated,

TIA,

Samuel
 
B

Bob Phillips

=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)
 
Top