Hi all.

I have a cell on sheet 1 (C4) that is titled (D)irect (A)gency. I want another column of cells on sheet 1 titled 'price' to select from prices on sheet 2 of the spreadsheet, dependent on whether D or A is entered in C4.

Sheet 2 already has a list of all of the direct and agency prices.

I hope that is understandable!