I'm trying to create a worksheet that populates cells corresponding to a cell chosen from a drop down list.
The list is a purchase item list with vendor names and numbers.
I'd like to be able to select the vendor number from a my drop down list in column E (which I've created using data validation) and I'd like the next cell F to be populated with the vendor name.
I don't know if I've entered the data range and created the drop down list correctly or if I've done something else wrong. The formula I have tried I used from a different thread in this forum but it's not working.
I've attached my worksheet for reference.
Thank you!!!
Dynette