Problem with CSE formula

pschepeler

New Member
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

Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
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?

Replies
0
Views
301
Replies
1
Views
249
Replies
2
Views
281
Replies
12
Views
608
Replies
8
Views
456

1,218,944
Messages
6,145,358
Members
450,611
Latest member
JodiWe

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.

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

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