Combining 2 cells to be put into 1 cell with Vlookup

  • Thread starter Thread starter Souljah
  • Start date Start date
S

Souljah

Hi

Basically, what I want to do is combine firstname and surname which ar
located in different columns - side by side though -

the function I'm using is -

=VLOOKUP($D$3,Order!B5:V60000,6,0)

Which posts the firstname into the cell I want, is it possible to ge
the surname AND the firstname into the same cell with a variation o
this function?

Thanks for any hel
 
Hi Souljah,

=VLOOKUP($D$3,Order!B5:V60000,6,0)&" "&VLOOKUP($D$3,Order!B5:V60000,7,0)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
brilliant thanks m8

would you be able to help wih one more - I'm looking up a date field i
another table which is in column A - the fields I am doing the looku
for are in column B, and the table array is from b1:U60000.
The thing is I get a date back if I use 1 as the coulmn index number i
this function, but the date is somthing, i dontk no where its from,
get like 5/18/1927 and the actual date is 6/6/2004 that i should b
getting.

is this clear
 
Probably what you get is not a date, but a number.
In Excel, dates are stored as number, 1/1/1900 being day 1.
Your "date" 5/18/1927 is exactly the number 10000

That is too coincidental to be true, agreed?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
indeed ur right as this is the number being referenced - is it possible
to refer to a column BEHIND the array referenced?
 
Souljah said:
indeed ur right as this is the number being referenced - is it possible
to refer to a column BEHIND the array referenced?
Click to expand...
Behind??? What's that mean?

Alan Beban
 
if the array referenced starts from from B - can u refer to A? becaus
just mking it stat from A does not seem to wor
 
Souljah said:
if the array referenced starts from from B - can u refer to A? because
just mking it stat from A does not seem to work
Click to expand...
=INDEX(A1:A8,MATCH(VLOOKUP(K1,B1:J8,6,0),G1:G8,0),1)

will return the value from Column A corresponding to the value from
Column G (the 6th column of B1:J8) that matches the value from B1:B8
that matches the value in K1.

Alan Beban
 
Back
Top