I would like to be able to look up Column O from Table3 located in Columns AL-AN and to leave Column O blank if there is Column S is blank. All of the columns currently have a vlookup formula in them. I don't understand the lookup match function.
I was using the following formulas but can't get them to work together:
=IF(E13="","",IF(E13="Sign","LED Channel Signage",IF((AND(E13="Interior",S13>250)),"Interior LED Fixtures replacing lamp(s) >250 Watts","Interior LED Fixtures replacing lamp(s) ≤ 250 Watts")))
=IF((AND(E13="Exterior",S13>250)),"Exterior LED Fixtures replacing lamp(s) >250 Watts","Exterior LED Fixtures replacing lamp(s) ≤ 250 Watts")
If I combine them I get You've entered too many arguments.
=IF(E13="","",IF(E13="Sign","LED Channel Signage",IF((AND(E13="Interior",S13>250)),"Interior LED Fixtures replacing lamp(s) >250 Watts","Interior LED Fixtures replacing lamp(s) ≤ 250 Watts",IF((AND(E13="Exterior",S13>250)),"Exterior LED Fixtures replacing lamp(s) >250 Watts","Exterior LED Fixtures replacing lamp(s) ≤ 250 Watts")))))
Is there a simpler way?
![](/board/proxy.php?image=https%3A%2F%2Fpreview.ibb.co%2Fm6y8PU%2FHelp.png&hash=9f2b1a991b04439bd85638bb6b352693)
what is sodium aluminum sulfate
I was using the following formulas but can't get them to work together:
=IF(E13="","",IF(E13="Sign","LED Channel Signage",IF((AND(E13="Interior",S13>250)),"Interior LED Fixtures replacing lamp(s) >250 Watts","Interior LED Fixtures replacing lamp(s) ≤ 250 Watts")))
=IF((AND(E13="Exterior",S13>250)),"Exterior LED Fixtures replacing lamp(s) >250 Watts","Exterior LED Fixtures replacing lamp(s) ≤ 250 Watts")
If I combine them I get You've entered too many arguments.
=IF(E13="","",IF(E13="Sign","LED Channel Signage",IF((AND(E13="Interior",S13>250)),"Interior LED Fixtures replacing lamp(s) >250 Watts","Interior LED Fixtures replacing lamp(s) ≤ 250 Watts",IF((AND(E13="Exterior",S13>250)),"Exterior LED Fixtures replacing lamp(s) >250 Watts","Exterior LED Fixtures replacing lamp(s) ≤ 250 Watts")))))
Is there a simpler way?
![](/board/proxy.php?image=https%3A%2F%2Fpreview.ibb.co%2Fm6y8PU%2FHelp.png&hash=9f2b1a991b04439bd85638bb6b352693)
what is sodium aluminum sulfate
Last edited: