Hello 2 questions,
#1
I am trying to make a worksheet where i add multiple Vlookup.

The numbers I want to pull from one table are dependent on other cells/ tables so i am not able to do simple addition. Here is what i want it to do (in simple form)

Ex.

(C1*D2)+(C3+G4)+..... and i want the number that appears in the cell to be the total. I can get excel to do what i want with a vlookup*another Vlookup. But i cannot get it to string multiple ones together like i wish.

The formula that i have and that works for just one set is:

=IFERROR(VLOOKUP(C38,Crew_Compositions,6,FALSE),"")*(VLOOKUP(E22,Labor_Code,3,FALSE))

I am not having problems with this part of the formula, but i am not able to add it to another set which is the same concept but different cells

#2 How do i do multiple if statements
I want a number out of say C4. But it needs to be dependent on A1 and B1. A1 Has 3 parts, so I am not able to use just A1 and B1 may be used a variety of times, but if it agrees with both it will give me the number i would like.

Any suggestions?

Hope this makes sense and any help would be appreciated