I am trying to make a formula that will take the value in one cell and place
a value in another cell. ex a1=shop then a2 would = 85 but if a1 = on site
then a2 would = 95. When I try this I get a #name? error.
Can any one help this beginner?