-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How to Possible match "List-1" & "List-2" Both number match & show Result "List-2" in item cell ???
- Thread starter krunal123
- Start date
Peter_SSs
MrExcel MVP, Moderator
- Joined
- May 28, 2005
- Messages
- 65,174
- Office Version
- 365
- Platform
- Windows
The earlier suggestion is fine, but since you have Excel 365 you could enter this formula in F4 and you wouldn't even need to copy it down, Excel would do that automatically for you.
| 20 12 14.xlsm | |||||||
|---|---|---|---|---|---|---|---|
| B | C | D | E | F | |||
| 1 | |||||||
| 2 | |||||||
| 3 | |||||||
| 4 | a | 1 | a | 1 | |||
| 5 | b | 2 | b | 2 | |||
| 6 | c | 3 | c | 3 | |||
| 7 | d | 4 | d | 4 | |||
| 8 | e | 5 | e | 5 | |||
Sheet2 (2) | |||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| F4:F8 | F4 | =VLOOKUP(E4:E8,B4:C8,2,0) |
| Dynamic array formulas. | ||
Upvote
0
Similar threads
- Question
- Solved
- Solved
