Automatically populating a cell

mvg

Hi everyone. Some help please.

I've been through index match but I don't think it's what I want. What I want to do is...

1. Someone submits a form with one of the fields being "sub job", selected from a dropdown.
2. Once I go into the spreadsheet after the form is submitted, I want the adjacent "WD no" column to be automatically populated.
3. I want it to be automatically populated from another sheet, based on the "sub job" form entry.

Thanks

*edited to add photo and extra steps.

Paul Newcome

It would be an INDEX/MATCH.

=INDEX({Reference Sheet WD no Column}, MATCH([Sub job]@row, {Reference Sheet CT subjob Column}, 0))

Paul Newcome

It would be an INDEX/MATCH.

=INDEX({Reference Sheet WD no Column}, MATCH([Sub job]@row, {Reference Sheet CT subjob Column}, 0))

mvg

Well I don't quite understand, but it worked. Thanks!

Paul Newcome

Happy to help. 👍️