Help with VLOOKUP and another value

[dandi10]

Hi, need help with this formula: =IF(VLOOKUP(A2,O:P,2,0)<=0.99 & (T2<=11),"3.5", "0")

What I need is that IF A2 is less than 0.99 and in the same time also less than T2, set value to 3.5 and if less, set to zero.

Thanks!

[Sam Capricci]

I think you want it this way...
=IF(AND(VLOOKUP(A2,O:P,2,0),T2<=11),"3.5","0")
you are looking to do an and statement.
now, if you want the output to be either 3.5 or 0 as TEXT, leave the quotes around them, if, however, you want them to be numbers, remove the quotes.

[dandi10]

Thanks but we are missing a value. I need 2 variations, the first VLOOKUP(A2,O:P,2,0)<=0.99 and also T2<=11

[Sam Capricci]

I need 2 variations, the first VLOOKUP(A2,O:P,2,0)<=0.99 and also T2<=11

You are saying AND also less than or equal to 11, the formula I gave you gives you the AND ALSO T2 being less than or equal to 11.
Have you tested it? Are you saying you need it to be OR T2 being less than or equal to 11?

Perhaps a small sample posted with some actual examples AND expected results (per the yellow banner at the top of the post) so I (we) can see what you have and what you want would be a help.

[dandi10]

Thanks, I have attached an excel. I need to set the formula in column E

[Sam Capricci]

sorry but I don't see any attachment, did you follow the instructions at the top of the post to attach a file?

[dandi10]

Hi! Hope you can see it now. What I need is that IF P2 is less than 0.99 and in the same time also less than T2, set value to 3.5 and if more, set to zero.

[Sam Capricci]

Sorry, still don't see it. They say there is a paperclip icon that people sometimes rely on but it doesn't work.
you have to click on the "go advanced" button below the quick reply window, then midway down you'll see in blue font "manage attachments", click on that and it will open a window where you can upload a file from your computer, choose the file, hit upload, close the window and hit submit reply and the attachment should appear.

[dandi10]

Uploading file

[dandi10]

Finally, sorry, file was too big and didn't see the error.

[Sam Capricci]

I think this might be what you are looking for... =IF(AND(VLOOKUP(A2,O:P,2,0)<0.99,T2<=11),"3.5","0")
but your first post says that

IF A2 is less than 0.99 and in the same time also less than T2

which tells me that this might be what you want...
=IF(AND(VLOOKUP(A2,O:P,2,0)<0.99,VLOOKUP(A2,O:P,2,0)<T2),"3.5","0")
but I'm not sure, the results returned for both of those formulas are no different than what you have now in cells E2 through E5.
Can you provide the correct answers if they are wrong?