Hi all, I'm trying (very hard) to populate a table based on the result in another cell. Have used Index Match and Lookup, but its starting to get a bit beyond me. Per table below, I am able to pull the comments in column E down into the "Work Required" Table and eliminate any gaps (using INDEX Function). What I can not seem to do do is get the check marks in the Poor, Avg and Excl columns from the top table to self populate in the 2nd table based on the input in Column A9 (pulled from Table 1) and below. Any help greatly appreciated.
<tbody>
</tbody>
TABLE 1 | ||||
Category | Poor | Avg | Excl | Comment |
Windows | X | Replace windows | ||
Doors | X | Paint Door | ||
Lawns | X | |||
Gardens | X | Tidy Garden | ||
Table 2 | ||||
Work Required | Poor | Avg | Excl | |
Replace windows | ||||
Paint Door | ||||
Tidy Garden | ||||
<tbody>
</tbody>