IF and VLOOKUP FORMULA

[Excel-Access]

I would be grateful if someone could help me combine an IF and LOOKUP formula in the attached spreasheet.

I have written in CELLS in N4 and N5 what I need to calculate Permanent and Contractor costs

Thanks a million

[benishiryo]

hi Excel-Access, try:
=IF(E4="permanant",VLOOKUP(H4,$A$35:$B$42,2,0),I4*J4)*M4

ps: should be "permanent" though

[dilipandey]

HI Excel-Access,

Use below formula:-

=IF($E4="Permanant",VLOOKUP($H4,$A$35:$B$46,2,0)*$M4,$I4*$J4*$M4)

see attached:-

Regards,
DILIPandey


<click on below 'star' if this helps>

[Legend Rubber]

formula for fte.xlsx

Beat me to it

[Fotis1991]

=IF(E4="Permanant",INDEX($B$35:$B$42,MATCH(H4,$A$35:$A$42,0)))*M4

[Legend Rubber]

@dilipandey
I dont know if that would work as there are 3 options...

[dilipandey]

@LegendRubber

yeah... realised after posting.. now corrected

Regards,
DILIPandey

<click on below 'star' if this helps>

[Excel-Access]

Thank you for this.

I do need the formula to be modified slightly to say that if E4 - Contractor, then it should pick a different formula IF E5 = CONTRACTOR, TAKE I5 MULTIPLY BY J5, MULTIPLY BY M5

Currently N5 formula is wrong. Can you help?

[Excel-Access]

Thank you very to all who have responded - most grateful.

The formula is not correct

I do need the formula to be modified slightly to say that if E4 - Contractor, then it should pick a different formula IF E5 = CONTRACTOR, TAKE I5 MULTIPLY BY J5, MULTIPLY BY M5

Currently N5 formula is wrong. Can you help?

[Ace_XL]

Adding on to Fotis' formula

=IF(E4="Permanant",INDEX($B$35:$B$42,MATCH(H4,$A$35:$A$42,0))*M4,IF(E4="Contractor",I4*J4*M4,""))