Help with this formula please

[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

 

[Don Guillett]

something like ??
=if(n3=w1,x1,"") and copy down

 

[Dave Potter]

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

 

[bigwheel]

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?

 

[Domenic]

Try the following array formula entered using CONTROL+SHIFT+ENTER...

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

Hope this helps

 

[CLR]

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