[h=2]Return Value Depending On Text In Cell[/h][INDENT]I have a large spreadsheet and I have a drop down bar that imports a list option in Cell E2. I am trying to figure out the formula to be inserted in Cell F2 that IF E2="Oatmeal Rasin", then Cell F2= $65.00, IF E2= "Chocolate Chip", then F2= $85.00 , etc....

My data is on Sheet E2 Cells A2:A10

I had a table set up on Sheet E2 (Separate Sheet) with corresponding costs? I received a helpful response of: "use a VLOOKUP formula like this:"

=VLOOKUP(E2,$X$2:$Y$10,2,FALSE)

where X2:Y10 contains the table of values... Adjust the ranges to suit your table location/size

Can someone give me the correct formula for data that is on a separate sheet? Thanks so much for the previous response....

RJ[/INDENT]