Drag down formula?

Hi there guys

I have a sheet here I am currently getting values from column K by manually clicking the cell and clicking the related value as you can see. I am just wondering is there a formula that can use and drag down to save me lots of time, if so what is it and could you tell me the cell to enter it in. I hope this is a nice easy question.

we like to help but as a mod will point out your thread title is not at all descriptive of your problem! and images are a no no unless its demonstrating a popup/error message or such.

hi,

Welcome to the forum

Can you please amend your thread title to be more descriptive of your problem (see rule #1 of the Forum Rules, via the FAQ section)?


Also, it has been said by people much wiser than I that...
If you want help with pictures - post a picture. If you want help with an Excel file - post an...

I'm off to bed now & will check out the thread again tomorrow, but I imagine that, if you are able to upload a small example file with dummy data, somebody will be able to help out fairly quickly (after your thread title is amended).

Edit: Martin beat me to it!
Oh well, repetition is considered important for learning too ;-)

Rob

Thank you for fixing your thread title

Can you pleas upload a sample file that is representative of your real file & contains a "before" & "after" with explanation?
Files can be uploaded in new posts using the "Go Advanced" post option & then the paperclip icon or the "Manage Attachments" button.

hth
Rob