Hi magicians!
I have two formulas that I want to make into one, if at all possible:
Formula one:
Formula two:
What I am trying to do is:
1 - vlookup A2&B2 against Sheet1 A:E
2 - if it exists, then within that vlookup table, if the value in column E is "Yes" then multiply H3*2 and if the answer is "No" simply produce H3 value.
3 - if doesn't exist, produce F2 value
So I kind of need to replace the "5" within the vlookup with formula 2? Bit weird I know, but is there anyway I can combine these into just one cell? Thanks!
I have two formulas that I want to make into one, if at all possible:
Formula one:
Excel Formula:
=IF(ISNA(VLOOKUP(A2&B2,'Sheet1'!A:E,5,FALSE)),F2,VLOOKUP(A2&B2,'Sheet1'!A:E,5,FALSE))
Formula two:
Excel Formula:
=IF('Sheet1'!E2="Yes",H3*2,H3)
What I am trying to do is:
1 - vlookup A2&B2 against Sheet1 A:E
2 - if it exists, then within that vlookup table, if the value in column E is "Yes" then multiply H3*2 and if the answer is "No" simply produce H3 value.
3 - if doesn't exist, produce F2 value
So I kind of need to replace the "5" within the vlookup with formula 2? Bit weird I know, but is there anyway I can combine these into just one cell? Thanks!