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
- 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
- Based on the values in cells b77 b81 ✓ - Excel Forum
- How would you change all cells containing the word pass to green - Excel Forum
- We couldn't find an account matching the login info you entered ✓ - Gmail 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
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 ....
