Hi there,
I'm looking to set up a Vlookup formula to pull through the whole numbers from a list base on what category they belong to.
So in column F if i wanted the whole numbers associated with the planning category it would return 1, 2 & 3. If i wanted the numbers associated with PMO it would read 4 & 5. Each number would have it own cell.
Does anyone have any thoughts.
regards,
john,
I'm looking to set up a Vlookup formula to pull through the whole numbers from a list base on what category they belong to.
So in column F if i wanted the whole numbers associated with the planning category it would return 1, 2 & 3. If i wanted the numbers associated with PMO it would read 4 & 5. Each number would have it own cell.
Does anyone have any thoughts.
regards,
john,