Help with this formula please

  • Thread starter Thread starter Dave Potter
  • Start date Start date
D

Dave Potter

I need help creating a formula to do this:

If the value in n3 equals the value in w1 return the value in x1
OR if the value in n4 equals the value in w2 return the value in x2

and so on... through 8 cells

thanks,
Dave
 
Thanks Don but I want the answer to always go in cell k5

Would the best way to do this be a VLOOKUP? or is there another way to
accomplish this?

Dave
 
Just a thought, Dave

How are you going to know which comparison resulted in K5 changing? What
happens if two or more cells that you are comparing would make K5 change?
 
Try the following array formula entered using CONTROL+SHIFT+ENTER...

=INDEX(X1:X8,MATCH(TRUE,N3:N10=W1:W8,0))

Hope this helps
 
Maybe...........

=IF(OR(N3=W1,N4=W2,N5=W3,N6=W4)=TRUE,IF(N3=W1,X1,IF(N4=W2,X2,IF(N5=W3,X3,IF(
N6=W4,X4)))),IF(N7=W5,X5,IF(N8=W6,X6,IF(N9=W7,X7,IF(N10=W8,X8)))))


Vaya con Dios,
Chuck, CABGx3
 
Back
Top