Need to do vlookup and return differen values
Closed
Farzi
-
Sep 9, 2008 at 09:10 PM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - Apr 28, 2009 at 03:42 AM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - Apr 28, 2009 at 03:42 AM
Related:
- Need to do vlookup and return differen values
- Flipkart return comments - Guide
- Zuma return - Download - Puzzle
- Return receipt email - Guide
- If cell contains date then return value ✓ - Excel Forum
- If cell contains specific text then return value in another cell ✓ - Excel Forum
3 responses
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
165
Apr 28, 2009 at 03:42 AM
Apr 28, 2009 at 03:42 AM
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 }
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 }
laptopman
Posts
15
Registration date
Thursday July 31, 2008
Status
Member
Last seen
October 18, 2008
3
Sep 10, 2008 at 04:10 AM
Sep 10, 2008 at 04:10 AM
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
are you trying to do that in excel?
if yes just see the help on macros on the forum itself it might help you
