How to return more than one value with multiple serach values with vlookup
I have two columns ID and C. Based on a vlooup formula in C with the search value in ID and need to show the value in C.
My Question here is when I need to show multiple values based on multiple IDs. Example: If ID1=Result1 ID2=Result2 and ID3=Result3 and in ID column I write 1 2 or something like this and i want to show Result1 and Result2 in column C.
Note: The ID and C values are based in another Sheet.