Cell Depandencies

[MaryV]

I am trying to select a part number from a list in cell A1 and would like cell B1 automatically select the coresponding part name. "IF" statements come to mind but I have about 100+ part numbers. How can i do it?

[Pete_UK]

You would normally use VLOOKUP to do this, rather than multiple IF statements joined together. Post an example of your workbook so that it is easier to give you a bespoke answer to suit your data.

Pete

[MaryV]

Thanks, that is working just fine.