So,
2 seperate formulas that i would like to read into the same cell. I have got both working independently but cannot figure out why they will not work together...
=IF(C7="WST",IF(I7="","",VLOOKUP(J7,Data!B:H,7,FALSE))) This works...
=IF(C7="Maxims",INDEX(Data!$AA$6:$AJ$31,M7,VLOOKUP(I7,Data!A:I,9,0)),"") This works...
=IF(C7="WST",IF(I7="","",VLOOKUP(J7,Data!B:H,7,IF(C7="Maxims",INDEX(Data!$AA$6:$AJ$31,M7,VLOOKUP(I7,Data!A:I,9))))),"") This works for "WST" but not reading "MAXIMS".
Please HELP!!!!!!!!!
Bookmarks