recently I was helped with a formula - where I was needing a value off of
sheet 1 to be placed on sheet 2

the formula that worked: =if(pricing!$c$2=1, pricing!b15,"") this works,
but what I found is in order to make this work, the pricing sheet needs to
show c2 with the 1 value, when I book the same formula for another item, the
c2 will have a different value, therefore the first formula results in a zero
- how can I make it a contant?

c2 in the pricing sheet reflects a chart with many items, I scroll on the
item wanted, and the c2 changes and makes the whole pricing sheet change to
reflect costs for that item - then when I want another item: I scroll the
chart and click - and c2 changes

This is confusing to me as well, I hope someone can read between this comboble
thank you