Using lookup functions with an if function

[Frazal]

Hello,

I'm trying to have a function reference one cell, in this case F762, to see if it says yes. If it does, it will print a value based off the value in G762, using a lookup function I've already proven to work. If the condition is not met, it should use a different lookup function that is also confirmed to work.

Here is my function:

=IF(F762="YES",=LOOKUP(G762,{-9.99999999999999E+307,"";10000,"20";25000,"40";50000,"56";100000,"100";250000,"125";500000,"150";1000000,"200"}),=LOOKUP(G926,{-9.99999999999999E+307,"6";10000,"9";25000,"18";50000,"45";100000,"75";250000,"100";500000,"150";1000000,"200"}))

What am I missing here that prevents this?

Thank you!

 

[Frazal]

Sorry, error in the code I posted with the second lookup, it's actually:

=IF(F762="YES",=LOOKUP(G762,{-9.99999999999999E+307,"";10000,"20";25000,"40";50000,"56";100000,"100";250000,"125";500000,"150";1000000,"200"}),=LOOKUP(G762,{-9.99999999999999E+307,"6";10000,"9";25000,"18";50000,"45";100000,"75";250000,"100";500000,"150";1000000,"200"}))

 

[jtakw]

Hi,

Since you say your formulas are Proven to work for you, I'm Only correcting your combined formula syntax:

Book1
	C
1	6
Sheet75

Cell Formulas
Range	Formula
C1	=IF(F762="YES",LOOKUP(G762,{-9.99999999999999E+307,"";10000,"20";25000,"40";50000,"56";100000,"100";250000,"125";500000,"150";1000000,"200"}),LOOKUP(G762,{-9.99999999999999E+307,"6";10000,"9";25000,"18";50000,"45";100000,"75";250000,"100";500000,"150";1000000,"200"}))

 

[Frazal]

Worked perfectly! Thank you so much!

 

[jtakw]

You're welcome, welcome to the forum.