thorpyuk
Well-known Member
- Joined
- Mar 14, 2006
- Messages
- 1,453
Hi,
A part of my coersion isn't working here (my OR statement):
If anyone can see what i'm doing wrong then i would be gratefull! Thanks
A part of my coersion isn't working here (my OR statement):
Rich (BB code):
=INDEX(Prices!$C$3:$C$2596,MATCH(LARGE(IF(Prices!$B$3:$B$2596=$F4,IF(((Prices!$J$3:$J$2596="Criteria1")*(Prices!$U$3:$U$2596=VLOOKUP(U4,Prices!$C:$U,19,FALSE))*(OR(Prices!$V$3:$V$2596="0",Prices!$V$3:$V$2596=$D4))*(Prices!$G$3:$G$2596="Criteria2")),Prices!$Q$3:$Q$2596)),1),Prices!$Q$3:$Q$2596,0))
If anyone can see what i'm doing wrong then i would be gratefull! Thanks