Auto entry depending on dropdown selection

I am hoping i can get some help to do the following:

If an entry on column C3-C499 matches the name '5212 IP' then have the extension number in the corresponding row of column be automatically be entered into sheet '12's labels' cell A13, if there are 2 entries (different rows) of selection '5212 IP' then the second auto entry to occur on cell C13 of '12's labels'

If an entry on column C3-C499 matches the name '5224 IP' then have the extension number in the corresponding row of that column be auto entered into sheet ' 24's labels' under cell B14. If there are multiple entries then the second one would be under F14 so on and so on.

I have manually entered the info on all '12's' and '24's' sheet to represent what i'm hoping to accomplish.

Thank you very much in advance for any help on this

does this look doable?

Hi breal,

The simple way to do this kind of job is using vlookup but, this has to work from left to right and your data is from right to left.

secondly, you want to search for the same thing multiple times - vlookup falls flat with this!

it may be possible using VB - but that'soutside my expertise, I'm afraid.

Regards

Ed

thank you very much edmac, was worth a try )