Problem with CSE formula

pschepeler

New Member
Joined
Sep 2, 2002
Messages
2
I'm having trouble with a CSE formula.
I have a worksheet ([EXPORTS]EXPORTS) that has several data relating to foreign trade... and I need to make a sheet for each country (TABLE A) involved showing only some of that data.

The thing's like this: I need to compare three cells (Country code, year, commodity code) from TABLE A with three ranges from[EXPORTS]EXPORTS with all the data, and return a value from the corresponding fourth range (commodity value).

I made a CSE formula that looks like this:
{=IF([EXPORTS]'EXPORTS!$A$2:$A$6700='TABLE A'!$A$1,IF([EXPORTS]'EXPORTS'!$C$2:$C$6700 ='TABLE A'!E$5,IF([EXPORTS]'EXPORTS'!$D$2:$D$6700='TABLE A'!$U8,[EXPORTS]'EXPORTS'!$L$2:$L$6700,"..."),"..."),"...")}

On the country sheet (TABLE A), the years go in the E row, the commodity codes on the U column, and the country code on the A1 cell.

The idea is to change the country code to get the corresponding data.

I always get the "...", so i never get a TRUE value from the IFs. I just can't get it to work. PLEASE HELP.
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Jim North

MrExcel MVP
Joined
Jun 20, 2002
Messages
791
I'm trying to get a picture... is this what your spreadsheets look like:

EXPORTS:
exports.xls
BCDEFGHIJKLM
1USA2002GOLD
2UK2001SILVER
3
4
EXPORTS


Table A:
exports.xls
ABCDEFGHIJKLMNOPQRSTUV
1UK2001SILVER
2
3
Table A


What are you accumulating? On which sheet? in what column?
 

Forum statistics

Threads
1,144,360
Messages
5,723,902
Members
422,525
Latest member
dsenff

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top