How DO I combine these 2 functions?

Im having trouble combining these two functions. I need the first one to operate first and then the second function. Both work separately but not when I put them together in the same cell which I need to?

=VLOOKUP(B21,$AC$1:$AD$10,2)

=IF(AND(F20>F21,F22>F21),F20,F21)

THanks Again

How do you want them 'put together'? Some information is missing.

If there are 2 alternatives:
=IF(AND(F20>F21,F22>F21),VLOOKUP(B21,$AC$1:$AD$10,2),F21) ???

If there are 3 alternatives:
=CHOOSE(1+(F20>F21)*(F22>F21)+...,F21,F20,VLOOKUP(B21,$AC$1:$AD$10,2)) ???

Ola Sandström

I need it to go together like below and procees the VLOOKUp first and then the IFAND


=VLOOKUP(B21,$AC$1:$AD$10,2)=IF(AND(F20>F21,F22>F21),F20,F21)

So How do I writearrange this so Function 1 executes then functions 2

Function 1=VLOOKUP(B21,$AC$1:$AD$10,2)

Function 2=IF(AND(F20>F21,F22>F21),F20,F21)

Okey, this is an unusual arrangement but ... it will give you a TRUE, FALSE or "" in return - ("" in case of an error). It will not return any 'value'.

=IF(ISERROR(VLOOKUP(B21,$AC$1:$AD$10,2)=IF(AND(F20>F21,F22>F21),F20,F21)),"",(VLOOKUP(B21,$AC$1:$AD$10,2)=IF(AND(F20>F21,F22>F21),F20,F21))

Hope it's what you're looking for

Ola Sandström