[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]