Hi, if someone can assist me it will be greatly appreciated.
I need to automatically insert a value to a cell based on a word in an adjacent cell.
Using =IF(ISNUMBER..... and =IF(ISERROR.... I have managed to find a single word from a cell (cell F2 - with a dropdown consisting of 2 options) and add a value to the adjacent cell but I need to add a different value to the adjacent cell based on the word in F2:
A) Cell F2 is a dropdown cell with "CSE" or "JCP"
B) If CSE is selected, the adjacent cell (G2) needs to be automatically populated with 2.50. If JCP is selected, G2 needs to be populated with 1.67
D) I also need to know what to do if I add a 3rd option to the dropdown which needs a completely different value.
E) If cell F2 is blank, then cell G2 should also remain blank.
Please assist.
Bookmarks