If I select a value from drop-down list, how to display related info in another cell?

Hi,

The title is confusing but there were not enough space.

dropdownlistsdisplayinfo.jpg

The case:

- I have 3 invoice numbers: 1005, 2062 and 3022 (fields A3, A4 and A5)
- Each invoice can have one of statuses: waiting, not paid or paid (fields D9, D10 and D11)

Question:

If I select invoice 1005 in field A2, how can I show the invoice's status in field B2?

It was my question. How can I make relation between cells? In this case between A3 and B3, A4 and B4....
Please advise if you have any other solution. Thanks

What he's trying to say is how does excel determine if the invoice is waiting, not paid or paid? It's simple enough to reference another cell, but is it based on the invoice on another sheet or is the information coming from somewhere else?

There is another drop-down with 3 statuses (you can see 3 statuses in picture attached - fields d9, d10 and d11).
Everytime when I add new invoice, I need to add dropdown for it in the next - field and I can change the status any time.
I just need to make relation between fields A3 and B3, A4 and B4 etc so whenever I select invoice in A2, updated status of it would be shown in B2.

Sorry, it's sounds bit confusing - I could do it probably different from the beginning.

Can anybody help? Other solutions are welcome for solve the problem as well. Thanks!

OK, I made another set of pictures for the case:

Excel_dropdown_question.jpg

Picture 1: This is regular display for invoices - invoice number and invoice status
Picture 2: I can select any invoices from dropdown
Picture 3: If I click on + on the side, complete list of invoices appears with statuses
Picture 4: I can select any of three statuses (paid, not paid or waiting) for any invoice
Picture 5: There is no excel relation between fields A3-B3, A4-B4... A7-B7. It's only visual relation for me - the status of the invoice is in the field next to the invoice. I need to make some kind of relation between A3 and B3 because Excel needs to know that the status in B3 is status of invoice in A3
Picture 6: The result: When I select invoice number in field A2, the field B2 should show the status of selected invoice

It works!!! Thanks NBVC. You helped me a lot!
What actually this command do? Maybe I can use it to organize some other cells

Thank you once again!