Lookup Match?

[IESEnergy]

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?


what is sodium aluminum sulfate

 

[Peter_SSs]

For the future, you will get many more potential helpers if you post a small (copyable) screen shot. My signature block below has help regarding that. We cannot copy from pictures.

See if this could be any use.
Add another column to your second table. The extra column should hold the upper wattage limit of any range the row applies to. For the ">" ranges, choose any number that is larger than anything that will ever appear in column S.
Use the formula shown in column O, adjusting the table name of the second table to match yours.

Excel Workbook
	E	O	S	AJ	AK	AL	AM	AN	AO
6	Fixture Location	Post-Fixture Category	Existing Watts Per Fixture			Location	Post-Fixture Category	Watts	Upper Limit
7	Exterior	="","",INDEX(Table2,AGGREGATE(14,6,(ROW(Table2)-ROW(Table2,]))/((Table2=])*(Table2>=])),1)))]Description 1	1080			Exterior	Description 1	>250	100000
8	Exterior	Description 1	1080			Exterior	Description 2		250
9	Exterior	Description 2	219			Interior	Description 3	>250	100000
10	Exterior	Description 2	219			Interior	Description 4		250
11	Exterior	Description 2	219			Sign	Description 5	N/A	100000
12	Exterior	Description 2	219
13	Sign	Description 5	145
14	Interior	Description 4	222
15
16
Category

 

[IESEnergy]

Thank you very much. That worked perfectly. Next time I will post a photo that can be copied and pasted!

 

[Peter_SSs]

Thank you very much. That worked perfectly.

You're welcome. Thanks for the follow-up.