I need to look up specific data based on a format like:

Project Number 1 (in column A)
Transportation (in column B) $500 (in column C)
Structural $50
Water $250

Project Number 2 (in column A)
Transportation (in Column B) $75 (in column C)
Structural $100
Water $250....etc.

So I first need to lookup the project number and then lookup transportation or Structural or Water and return the dollar value. This needs to be done using a lookup or something because each month a new report is generated and the cell location of Project Number 1..2..etc. will change from month to month so I don't have a fixed cell location for any of the data.

Any ideas how to look this data up?

Thank you.