My table for vlookup: A1:B4
1110 2 or it can have one key 1110 2
1110 3 3
1120 4 1120 4
1120 5 5
I need the function to return all data associated with the value.
so when I look up 1110, i get 2 and 3 in different cells such as
2
3
My table for vlookup: A1:B4
1110 2 or it can have one key 1110 2
1110 3 3
1120 4 1120 4
1120 5 5
I need the function to return all data associated with the value.
so when I look up 1110, i get 2 and 3 in different cells such as
2
3
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks