Dazzybeeguy
Board Regular
- Joined
- Jan 6, 2022
- Messages
- 72
- Office Version
- 365
- 2010
- Platform
- Windows
If I have a vlookup that in say Cell E2 looks for the Ref i.e A1234 and I want the 2nd column as my result.
The ref A1234 appears 4 times so I want formulas in Cell E3, E4 & E5
Cell E2 Formula =VLOOKUP("A1234",A1:B10,2,FALSE)
How do I get all four results and not the first result 4 times in cells E3:E5
So I want to get the following
E2 = Dig, E3 = Paint, E4 = Iron, E5 = Hoover
The ref A1234 appears 4 times so I want formulas in Cell E3, E4 & E5
Cell E2 Formula =VLOOKUP("A1234",A1:B10,2,FALSE)
How do I get all four results and not the first result 4 times in cells E3:E5
So I want to get the following
E2 = Dig, E3 = Paint, E4 = Iron, E5 = Hoover
Reference (Column A) | Task (Column B) |
A1234 | Dig |
A1235 | D |
A1234 | Paint |
A1237 | A |
A1238 | C |
A1234 | Iron |
A1240 | A |
A1244 | C |
A1234 | Hoover |