Matching cells
Closed
vefm
-
May 19, 2009 at 08:35 AM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - May 21, 2009 at 02:45 AM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - May 21, 2009 at 02:45 AM
Related:
- Matching cells
- Based on the values in cells b77 ✓ - Excel Forum
- We couldn't find an account matching the login info you entered, but found an account that closely matches based on your login history. - Excel Forum
- We couldn't find an account matching the login info you entered, but found an account that closely matches based on your login history - Facebook Forum
- We couldn't find an account matching the login info you entered - Laptop Forum
- Why do we not open our account having the same username? ✓ - Gmail Forum
2 responses
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
May 19, 2009 at 11:32 PM
May 19, 2009 at 11:32 PM
Hi
In column B of Sheet 2, put the formula =vlookup(A1,Sheet1- entire range,2, false)
In column C of Sheet 2, put the formula =vlookup(A1,Sheet1- entire range,3, false)
Do let me know If it helps...
In column B of Sheet 2, put the formula =vlookup(A1,Sheet1- entire range,2, false)
In column C of Sheet 2, put the formula =vlookup(A1,Sheet1- entire range,3, false)
Do let me know If it helps...
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
166
May 21, 2009 at 02:45 AM
May 21, 2009 at 02:45 AM
Vlooku is good option but make sure account numbers are not repeating in column A bcoz vlookup will fail to pick 2nd occurrence of the repeated account number ....
