I am setting up my worksheet and figured out most things, but what is the
proper sintax for referencing data on a separate sheet?

I can get the formula to work if the information is in the same worksheet.
I need to create a user worksheet that they just use to enter the lookup
parameters.

Here is my formula:

=IF(COUNTA(D5,D7,D9,D11)<4,"",INDEX(INFO!B3:B50,MA TCH(1,(Model=$D5)*(Volts=$D7)*(hz=$D9)*(phase=$D11 ),0)))

The part referncing the other sheet is the "(INFO!B3:B50....." Info is the
worksheet name and the B3:B50 is obviously the range of Data.

Thank you for the help.

Raymond

Your syntax is correct.

Are you getting errors?

INFO is an XL function; give your sheet a different name.
--
Brevity is the soul of wit.


"broderp" wrote:

I am setting up my worksheet and figured out most things, but what is the
proper sintax for referencing data on a separate sheet?

I can get the formula to work if the information is in the same worksheet.
I need to create a user worksheet that they just use to enter the lookup
parameters.

Here is my formula:

=IF(COUNTA(D5,D7,D9,D11)<4,"",INDEX(INFO!B3:B50,MA TCH(1,(Model=$D5)*(Volts=$D7)*(hz=$D9)*(phase=$D11 ),0)))

The part referncing the other sheet is the "(INFO!B3:B50....." Info is the
worksheet name and the B3:B50 is obviously the range of Data.

Thank you for the help.

Raymond