IF statement ith VLookup and Index help needed

[Greenrev]

Hello,
I have an IF statement that I need to use a VLOOKUP and an INDEX to bring in data. I can get the VLOOKUP to work correctly, but whenever I set the parameters to return the INDEX info I get a "#Value!" returned. I think it may be paranthese placement, but I can't seem to figure it out. Here is how I have my formula entered:
=IF($B$34="Yes",VLOOKUP($B$37,'Lumber Specs'!$E$27:$K$33,2),INDEX('Lumber Specs'!$F15:$XX15,MATCH($B$29&B$30,'Lumber Specs'!$F$13:$XX$13&'Lumber Specs'!$F$14:$XX$14,0)))
Any help would be greatly appreciated!

 

[Jonmo1]

That's an array formula that requires a Special keystroke entry.

After typing the formula, don't press enter
Instead, press CTRL + SHIFT + ENTER
When entered correctly, the formula will be enclosed in {brackets}

 

[Greenrev]

Eureka! That was it! I forgot about the CTRL+SHIFT+ENTER. Thanks much. I was pulling my hair out over here.

 

[Jonmo1]

You're welcome.