What would the proper syntax be for this formula or is this even possible with formula? Hopefully, this is enough to give you the gist of what I am trying to do.
IF A1 = $B$1 then C1 = $D$1 OR IF A1 = $B$2 then C1 = $D$2 OR IF A1 = $B$3 then C1 = $D$3
Column B references items (i.e. Apple, Banana, Pear) and column D references prices ($1.20, $1.50, $0.75)
So if A1 is "Apple" then C1 is $1.20 but if A1 is "Banana" then C1 is $1.50.
Any help is much appreciated. Thanks.
Bookmarks