I have a spreadsheet where I have approx. 50 product codes. When I select a product code, I want Excel to fill in the cost (from a list on a separate sheet) in the cell next to the product code. In the past I've used nested "IF" statements, but I have what appears to be more ifs than exel can handle.
Thanks for the help
Thanks for the help