IF with Vlookup

[Jaime Hardeman]

I have a formula that I need to rework.  I just found out that I can't have more than 7 If statements in one formula.  Can anyway suggest something?

=IF($I7='SKU Worksheet'!$I$6,VLOOKUP('Store Worksheet'!J$6,'SKU Worksheet'!$G:$V,3,FALSE),If($I7='SKU Worksheet'!$J$6,VLOOKUP('Store Worksheet'!J$6,'SKU Worksheet'!$G:$V,4,FALSE),IF($I7='SKU Worksheet'!$K$6,VLOOKUP('Store Worksheet'!J$6,'SKU Worksheet'!$G:$V,5,FALSE),IF($I7='SKU Worksheet'!$L$6,VLOOKUP('Store Worksheet'!J$6,'SKU Worksheet'!$G:$V,6,FALSE),IF($I7='SKU Worksheet'!$M$6,VLOOKUP('Store Worksheet'!J$6,'SKU Worksheet'!$G:$V,7,FALSE),IF($I7='SKU Worksheet'!$N$6,VLOOKUP('Store Worksheet'!J$6,'SKU Worksheet'!$G:$V,8,FALSE),IF($I7='SKU Worksheet'!$O$6,VLOOKUP('Store Worksheet'!J$6,'SKU Worksheet'!$G:$V,9,FALSE),IF($I7='SKU Worksheet'!$P$6,VLOOKUP('Store Worksheet'!J$6,'SKU Worksheet'!$G:$V,10,FALSE),IF($I7='SKU Worksheet'!$Q$6,VLOOKUP('Store Worksheet'!J$6,'SKU Worksheet'!$G:$V,11,FALSE),IF($I7='SKU Worksheet'!$R$6,VLOOKUP('Store Worksheet'!J$6,'SKU Worksheet'!$G:$V,12,FALSE),IF($I7='SKU Worksheet'!$S$6,VLOOKUP('Store Worksheet'!J$6,'SKU Worksheet'!$G:$V,13,FALSE),IF($I7='SKU Worksheet'!$T$6,VLOOKUP('Store Worksheet'!J$6,'SKU Worksheet'!$G:$V,14,FALSE),IF($I7='SKU Worksheet'!$U$6,VLOOKUP('Store Worksheet'!J$6,'SKU Worksheet'!$G:$V,15,FALSE),IF($I7='SKU Worksheet'!$V$6,VLOOKUP('Store Worksheet'!J$6,'SKU Worksheet'!$G:$V,16,FALSE),"-"))))))))))))))

[Ashish Kumar]

Hi,

Share your query with the question and required output.

Regards

Ashish Kumar