VLOOKUP, INDEX MATCH

[j4ymf]

Hello All

Not sure what type of formula i need here if its needs to be a VLOOKUP or INDEX MATCH

=VLOOKUP(I9,Lookup!$C$4:$AV$3004,$O$18,FALSE)

the formula above is in J19

How would i write the forumla to return the construction type value based on the result .

somthing like INDEX I9, and match the construction type

Rigid Wall is VLOOKUP(I9,Lookup!$C$4:$AV$3004,$O$18,FALSE)
Rigid Soffit is $O$19 VLOOKUP(I9,Lookup!$C$4:$AV$3004,$O$19,FALSE)
Rigid floor is $O$20 VLOOKUP(I9,Lookup!$C$4:$AV$3004,$O$20,FALSE)

 

[Kaper]

So if I understand well I9 shall be found in Lookup!$C$4:$C$3004 and final value returned from column 12, 13, 10, etc in Lookup!$C$4:$AV$3004 range

  =VLOOKUP(I9,Lookup!$C$4:$AV$3004,VLOOKUP(I19,N18:O22,2,FALSE),FALSE)

 

[j4ymf]

Kaper, WOW, not sure how you understood my question but thank you so much for you help, thats it thank you

 

[Kaper]

Glad we could help and thanks for marking answer as a solution