Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 22nd 06, 08:41 AM posted to microsoft.public.excel.newusers
MikeR-Oz
 
Posts: n/a
Default Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE)

I have a sheet named "lookUp" that has 3 columns

emp No Name Mobile No.
11111 Bruce, Jack lincoln 0404 126 561

and I have been given this:-

=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE)

Which takes the info from the "LookUp" sheet to another sheet and puts the
name in to a cell.

But a new "LookUp1" sheet is laid out as

emp No Surname First Name Mobile No.
11111 Bruce Jack lincoln 0404 126 561

How can I change the Vlookup to now put both the Surname PLUS a comma and
then the First name all into the 1 cell in the sheet seeing that the new
LookUp1 nows seperates the surname(bruce) from the first names ??

So want

enter 1111

get

Bruce, Jack lincoln

Mike


  #2   Report Post  
Old March 22nd 06, 10:01 AM posted to microsoft.public.excel.newusers
Clivey_UK
 
Posts: n/a
Default Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE)


Hi Mike,
I think you should use the & symbol to add two bits of text. Try this:
=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE)&",
"&VLOOKUP(F9,LookUp1!$A$2:$B$1504,3,FALSE)
What this will do is lookup 1111 and return Bruce from the 2nd column,
then it will add ", " and then it will add Jack Lincoln from coloumn 3,
so the result is
Bruce, Jack Lincoln.
Clive

MikeR-Oz Wrote:
I have a sheet named "lookUp" that has 3 columns

emp No Name Mobile No.
11111 Bruce, Jack lincoln 0404 126 561

and I have been given this:-

=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE)

Which takes the info from the "LookUp" sheet to another sheet and puts
the
name in to a cell.

But a new "LookUp1" sheet is laid out as

emp No Surname First Name Mobile No.
11111 Bruce Jack lincoln 0404 126
561

How can I change the Vlookup to now put both the Surname PLUS a comma
and
then the First name all into the 1 cell in the sheet seeing that the
new
LookUp1 nows seperates the surname(bruce) from the first names ??

So want

enter 1111

get

Bruce, Jack lincoln

Mike



--
Clivey_UK
------------------------------------------------------------------------
Clivey_UK's Profile: http://www.excelforum.com/member.php...o&userid=32569
View this thread: http://www.excelforum.com/showthread...hreadid=525139



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using single cell reference as table array argument in Vlookup CornNiblet Excel Worksheet Functions 3 September 22nd 05 09:15 AM
VLOOKUP Limitations chris_manning Excel Worksheet Functions 2 August 9th 05 06:23 PM
Have Vlookup return a Value of 0 instead of #N/A Mr Mike Excel Worksheet Functions 4 May 25th 05 04:51 PM
vlookup data hidden within worksheet Excel Worksheet Functions 0 January 26th 05 01:09 PM
Vlookup info being used without vlookup table attached? Excel Worksheet Functions 0 January 25th 05 11:43 AM


All times are GMT +1. The time now is 05:34 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017