In cell B4 I have a validation dropdown list of 4 titles. Title 1, 2, 3, 4.
In cell G-4 I would like a dollar amount to be placed in that cell in
reference to what is selected in B4. When I place =if(B4"Title1"="$110") I
can select Title 1 and have that correct dollar amount appear in the G4 cell.
Can I write a statement that will give me different dollar amounts for the
four different titles? Thank you in advance