Hi,
I am trying to figure this one out, Hopefully someone can help me.
Basically I have a sheet like this:
<tbody>
</tbody>
I have a separate sheet with all the post names and I am running a VLOOKUP formula for the "Post Names" column but what I need is to have whenever I put e.g Station 1 in to the "A" column that it will automatically populate columns B-D with the correct description, File code & audio file code, I have tried doing VLOOKUP for the other cells but the file is messy and puts in a lot of N/A & Blanks etc.
This sheet is going to cater for a whole route network and it would take months to type manually so hopefully someone has a smart IF formula that I just can't figure out.
Thanks.
I am trying to figure this one out, Hopefully someone can help me.
Basically I have a sheet like this:
Post Name | Announce Desc. | File code | Audio file code |
Station 1 | Station 1_welcome | 112 | B76 |
Station 2 | Station 2_welcome + Dept. | 1009 | Y677 |
<tbody>
</tbody>
I have a separate sheet with all the post names and I am running a VLOOKUP formula for the "Post Names" column but what I need is to have whenever I put e.g Station 1 in to the "A" column that it will automatically populate columns B-D with the correct description, File code & audio file code, I have tried doing VLOOKUP for the other cells but the file is messy and puts in a lot of N/A & Blanks etc.
This sheet is going to cater for a whole route network and it would take months to type manually so hopefully someone has a smart IF formula that I just can't figure out.
Thanks.