xtremeusta
New Member
- Joined
- Oct 9, 2022
- Messages
- 14
- Office Version
- 365
- Platform
- MacOS
if cell a1 = cell a2, index c1:c10, match b1, d1:d10, and if cell a1 = cell a1, devide the result of the index and match by e1
=IF(A1=A2,INDEX(C1:C10,MATCH(B1,D1:D10,0) ----- i am trying to get the result of this to then IF(A1=A2/D1,0)
is there a way to do this?
would really appreciate anyones help
=IF(A1=A2,INDEX(C1:C10,MATCH(B1,D1:D10,0) ----- i am trying to get the result of this to then IF(A1=A2/D1,0)
is there a way to do this?
would really appreciate anyones help