three values to return a fourth value

[fireguard]

Greetings all,

I have a project that has three values (an index, a wavelength and a time) in the cells: S43, U43 and W43 respectively.

Once those values are entered, those values are matched in a list and an equation is returned from a fourth column.
To match those values into the list I have used the following:

=INDEX(E62:E776,MATCH(1,IF(B62:B776=S43,IF(C62:C776=U43,IF(D62:D776=W43,1))),0))

Column E is the Equation that I require
Column B is the index
Column C is the wavelength
Column D is the time

At present, I keep getting a return of 0 (I believe this indicates a false).

I have previously used an equation on another project to match two values and return from a third column and it worked exceptional well. that formula was:
=INDEX(F29:F49,MATCH(A50&C54,A29:A49&B29:B63,0))

The issue being that when I tried adding a third value, I kept getting errors. The formula I used in this case was:

=INDEX(E62:E776,MATCH(S43&U43&W43,B62:B776&C62:C776&D62:D776,0))

Any assistance would be appreciated. If you require additional information, pls let me know.

Cheers

 

[James006]

Hi,

Since you are dealing with an Array formula ... hope you have not forgotten to use simultaneously the three keys : Control Shift Enter ...

 

[fireguard]

James006,
Thanks for the reply. Yes I am entering the three keys. Thanks again

fireguard

 

[James006]

James006,
Thanks for the reply. Yes I am entering the three keys. Thanks again

fireguard

Great ...

Should have already mentioned that your formula looks perfectly fine ...

You will need to dig further to find out what is going on ...

 

[fireguard]

Great ...

Should have already mentioned that your formula looks perfectly fine ...

You will need to dig further to find out what is going on ...

James006
Thanks. You comments are noted, I too am having trouble identifying the issue. I have started changing values to to see if the trouble is the same across other values.
Cheers