|The answer to your question depends on the layout of your data. Excel has various "lookup" functions such a VLOOKUP, INDEX, MATCH, etc. Each has its merits and its drawbacks.|
If you'll post a short example of your data, we could be more specific. Please click on the following line and read the instructions found via that link before posting your data. Thanks!
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.