Why does the VLOOKUP not work???

[kgoshia]

The issue I think with my formula is that second set of VLOOKUP that is separated by the (*) "circled in Orange.

My goal is that a user has to enter a value in cell E5 from 0-600 this represents an AC voltage range, and I will have 5 different augments about the voltage for example <50 VAC, 101-149 VAC, 150-200 VAC...... This part works perfect.

What does not work is that the user also has to make an entry in Cell E10 "where the red circle is" either a 1 or 2. The argument when you enter a 1 works, however when a 2 is entered it returns a "FALSE" statement.

My formula did not have the (*) between the 2 argument, but excel added this when if looks at the formula.

So at the end of the day all I want is to get the argument in Cell E10 to work whether there is a 1 or 2 entered into it.

Thanks

[/URL][/IMG]

 

[Special-K99]

You cant attach files on this forum.
Upload the file to an online storage site then place a link to it on this forum.

At present we cant see the formula at all because of the absence of the image.

 

[mole999]

my experience of the multiplication is sometime the formula is off, and excel gives that as an option until its fixed properly. If you are not expecting to multiply, then check the formula

 

[kgoshia]

You cant attach files on this forum.
Upload the file to an online storage site then place a link to it on this forum.

At present we cant see the formula at all because of the absence of the image.

=(IF(E5<=50,IF(E10=1,(VLOOKUP(1,'AC Mains Transient Voltage'!A5:F22,3,0)*(IF(E5<=50,IF(E10=2,(VLOOKUP(1,'AC Mains Transient Voltage'!A5:F22,5,0)))))))))

 

[mole999]

was this what you were trying to do

=IFERROR(IF(AND(E5<=50,E10=1),VLOOKUP(1,'AC Mains Transient Voltage'!A5:F22,3,0),IF(AND(E5<=50,E10=2),VLOOKUP(1,'AC Mains Transient Voltage'!A5:F22,5,0))),"")

 

[kgoshia]

was this what you were trying to do

=IFERROR(IF(AND(E5<=50,E10=1),VLOOKUP(1,'AC Mains Transient Voltage'!A5:F22,3,0),IF(AND(E5<=50,E10=2),VLOOKUP(1,'AC Mains Transient Voltage'!A5:F22,5,0))),"")

Ding,ding,ding it's a winner.Thank you so very very much