excel vlookup or index with if

kypok999

New Member
Joined
Oct 20, 2017
Messages
41
I uploaded the file so basically formula should look into column a first example it would look into A2:A12 because its one race with 11 horses it should into if AR2:AR11=1 and BT2:BT11<3 and it should the same time look if in the same race Power 2 AR2:AR11= 2 AP2:AP11<3 and BT2:BT11<3 then bet on A8 which is POWER 2 AR8=2 so it means if horse which is ranked by power 1 AR2=1 but Draw rank is more then 3 and 2nd Power ranked horse in column AR2 =2 and spend and draw ranks are less then 3 then it should bet on Power 2 horse it should look into unique value in A:AA if that makes sence
pic:
https://imgur.com/a/HU4JJ

file:
https://www.sendspace.com/file/1isig1
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
Hello,

Not sure to understand all of your requirements ...

What is the difference between cell CC6 and cell CC8 ... which both comply with your conditions ...???
 
Upvote 0
Hello James basically CC column currently puts two bets but I want one as when this both conditions are met so if both conditions are met then bet should be against A8 as in this race Power 2 is Speed < 3 and Draw < 3 is met which is A8 plus another condition is met [TABLE="width: 188"]
<tbody>[TR]
[TD="class: xl63, width: 188"]Power =1 Draw rank > 3 which is A6 so when both conditions are met bet should be places for only when Power rank =2 [/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0

Forum statistics

Threads
1,223,909
Messages
6,175,313
Members
452,634
Latest member
cpostell

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top