Hello,
I'm really struggling with this one. I believe I need to use an index match lookup combo. The goal is to pull information from sheet 1 into other "forms" (pre-populated sheets) in a workbook. I would like to return all information from column C that has the correct text in columns A, B and D. I'm only looking to meet these three criteria: base bid, fire alarm and quoted:
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
<tbody>
</tbody>
Sheet 2 I have labeled "Fire Alarm". So on sheet 2:
A1 would read "Smoke Det"
A2 would read "Heat Det"
A3 would read "Pull Station"
I would be very grateful for an answer!
Thank you
I'm really struggling with this one. I believe I need to use an index match lookup combo. The goal is to pull information from sheet 1 into other "forms" (pre-populated sheets) in a workbook. I would like to return all information from column C that has the correct text in columns A, B and D. I'm only looking to meet these three criteria: base bid, fire alarm and quoted:
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
A | B | C | D | ||
1 | Base Bid | Nurse Call |
<tbody> </tbody> | Quoted | |
2 | Base Bid | Nurse Call |
<tbody> </tbody> | Quoted | |
3 | Base Bid | Fire Alarm | Smoke Det | Quoted | |
4 | Base Bid | Fire Alarm | Heat Det | Quoted | |
5 | Base Bid | Fire Alarm | Pull Station | Quoted | |
6 | Base Bid | Security | Door Contact | Quoted |
<tbody>
</tbody>
Sheet 2 I have labeled "Fire Alarm". So on sheet 2:
A1 would read "Smoke Det"
A2 would read "Heat Det"
A3 would read "Pull Station"
I would be very grateful for an answer!
Thank you