Show Selected Customer ID #

[ApolloCarrierServ]

I have a worksheet with Customer Information. In Columns D-T is the Customers information Headers address, phone, email, etc. In column D are the Customers ID #'s I would like to take the Customer ID# for the selected customer and show it in Cell B2 . Is there a way to do this? I have attached a picture to try and help clarify.

https://www.dropbox.com/s/yloptcp1afhv1jo/Screenshot 2019-05-22 22.15.02.png?dl=0

 

[alansidman]

A picture is almost useless. We cannot manipulate and test the worksheet from a picture. Suggest if you are going to provide this type of documentation that you upload an actual sample worksheet.

 

[ApolloCarrierServ]

https://www.dropbox.com/s/0myb1hi5nmmmna0/Leads Sheet uploadScotty.xlsm?dl=0

Here is the actual worksheet. Sorry about that.

 

[AhoyNC]

Try:

=INDEX($D$14:$D$1880,$B$1-ROW($D$13))

 

[ApolloCarrierServ]

That worked perfectly! Thank you!

 

[AhoyNC]

You're welcome. Thanks for the feedback.