Search : in
By :

Need to do vlookup and return differen values

Last answer on Apr 28, 2009 8:42:32 am BST Farzi, on Sep 10, 2008 2:10:10 am BST 
 Report this message to moderators

Hello,
Hi,
I need to enter a name. The macro should then find it in a table and return the name and two other numbers in the same row.
Imagine Names are in Col A and Tel numbers in Col B and Mobiles in Col C.
I want to enter the name and see the result of a the name and corresponding numbers in a dialog box. Can anybody help me?
Thanks.

Configuration: Windows 2000
Internet Explorer 6.0

Best answers for « Need to do vlookup and return differen values » in :
Comparing columns and returning value Show
[VBA] A function that returns the color of an active MFC Show [VBA] A function that returns the color of an active MFC This function returns the value of the active format in conditional formatting. With the function below, two values can be returned. Mode = 0: the value of Interior.ColorIndex...
VB Code for returning a value in the same col Show
Excel - Comparing columns and returning value ShowExcel - Comparing columns and returning value Issue Solution Note Issue I have an Excel spreadsheet where I want to compare values between two columns and return the value from another column. EX: Column: A B C D ...
[VMWare] The different modes of VMWare network Show[VMWare] The different modes of VMWare network If you create a virtual machine using VMWare, 3 types of connectivity are provided: Host-only, NAT or Bridged. You can't use NAT and Bridged modes if you do not have the following...
VB6 Finding the RGB values of a color ShowVB6 Finding the RGB values of a color Dim R as integer Dim G as integer Dim B as integer Sub FindRGB(Col As Long) R = &HFF& And Col G = (&HFF00& And Col ) \ 256 B = (&HFF0000 And Col ) \ 65536 End Sub Note: Here...
UNIX Commands ShowTable of the main UNIX commands Unix Commands Description Options ls lists the content of a directory -a Displays all files, including hidden files -I Displays a...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Environment variables ShowEnvironment variables An environment variable is a dynamic value loaded into the memory that can be used by several processes operating simultaneously. On most operating systems, the location of some libraries or of the main system executables may...
Ask your question Reply

1

laptopman, on Sep 10, 2008 9:10:10 am BST
  • +1

Hey there,

are you trying to do that in excel?

if yes just see the help on macros on the forum itself it might help you

   
Reply to laptopman

2

Farzi, on Sep 10, 2008 9:58:29 pm BST
  • +2

Thanks for the reply.
Yes. In Excel. But I could not find help on macros in the forum.

   
Reply to Farzi

3

gf, on Apr 28, 2009 1:00:43 am BST
  • +1

Did you figure out how to do this on excel?

   
Reply to gf

4

 mubashir aziz, on Apr 28, 2009 8:42:32 am BST

Suppose your data is in Sheet from Cell A2 to C8 .....

Now in Sheet2 in Cell A1 write a name which is in sheet1 and now in Sheet 2 write below formula's

A2=VLOOKUP($A$1,Sheet1!$A$2:$C$8,1,FALSE) {It will search name in Sheet 1 on the basis of Sheet2!A1 }
B2=VLOOKUP($A$1,Sheet1!$A$2:$C$8,2,FALSE) {It will return phone number from Sheet 1 on the basis of Sheet2!A1 }
C2=VLOOKUP($A$1,Sheet1!$A$2:$C$8,3,FALSE) {It will return mobile number from Sheet 1 on the basis of Sheet2!A1 }

   
Reply to mubashir aziz
Ask your question Reply
They need your help