=LOOKUP(B4,{"Title1","Title2","Title3","Title4";11 0,115,120,125})

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Mike Busch" wrote in message
...
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