ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Multiple Ifs, can't use vlookup (https://www.excelbanter.com/excel-discussion-misc-queries/126361-multiple-ifs-cant-use-vlookup.html)

[email protected]

Multiple Ifs, can't use vlookup
 
Hi,

I have nine columns say column A to column I and each of them contain
some data and I have another column called "Code".
If column A is not empty ( even though the other column contain data)
then code=A
If column A is empty but column A is not empty then Code=B
......and so on.
For cells empty in column A through column I, I use Code"excluded"
I use formula
=IF((A2<""),"A",IF((b2<""),"B",IF((c2<""),"C",I F((d2<""),"D",if((e2<""),"E",if((f2<""),"F",If( (g2<""),"G",if((h<""),"H",
if((i2<""),"i","excluded")))))))))

But I found I can't have over 7 multiple ifs.

Can anyone give me a advice? How to fix my formula?

Thanks
Jenny



All times are GMT +1. The time now is 08:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com