Need help with some kind of LOOKUP formula to generate a list of required documents

[postgre]

Use Case
1. Table 1 contains the associated docs for a specific capability/service
2. The user enters a Y for one or more of the required capability/services
3. A formula checks for the required capability/services (Y entries) to determine which documents are required
4. An x is generated in the Table 2 (required column) for the required document

[benishiryo]

hi postgre, welcome to the forum. it looks like your Table 2 is only based on "Need Oven"? you can try this formula in B17:
=IF(HLOOKUP(A17,$C$7:$J$8,2,0)="X","X","")

copy down

[postgre]

using this formula I get #N/A value error (the required "Y" must drive the result entered in table 2)

i modified the formula to account for a user that enters a Y (need an oven = Yes)

=IF(B8="Y",IF(HLOOKUP(A17,$C$7:$J$8,2,0)="X","X",""),"")

However, this doesn't work for the entire of table 2 even if the range is expanded to $C$7:$J$12.

[sloninja]

Here you go, tab 1 is your info, tab 2 is short if statement, saying if you have a Y in blue cell, then the "X" will apply, if you won't change your requirement often, i recommend this one. third tab is vlookup statement, if you have a long complicated requirement list based on given information (tab 1) then use the vlookup tab.

[postgre]

Outstanding - thank you very much.