T
Ted Metro
I have a list of project numbers and their costs, and some project numbers
are represented multiple times.
I want a lookup that will return all of the values for a project.
Column A Column B
154 100
143 150
153 75
143 92
176 68
122 84
143 111
110 225
176 374
I have a list of the unique project numbers in Column C
143
153
154
176
122
110
In column D I'd like to see the first cost, in Column E (where applicable)
the second cost, in Column F the third cost, etc.
When I do a vlookup I can't tell it to grab the second instance of the
project number, but there has to be a way.
are represented multiple times.
I want a lookup that will return all of the values for a project.
Column A Column B
154 100
143 150
153 75
143 92
176 68
122 84
143 111
110 225
176 374
I have a list of the unique project numbers in Column C
143
153
154
176
122
110
In column D I'd like to see the first cost, in Column E (where applicable)
the second cost, in Column F the third cost, etc.
When I do a vlookup I can't tell it to grab the second instance of the
project number, but there has to be a way.