Selected Cell in a Range Appears in another Cell

N

Nick'o

I have a group of cells that represent different prices for items. When I
select one of these cells in the range of cells, I want the selected cell's
value to appear in another cell in the the same spreadsheet...
 
K

kassie

And when you select the next cell, the value will change again? And again and
so on?
You would be much better off making use of criteria, to select either an A,
B, or C price. Iow, if you insert an "A", you get price 1, a "B" will give
you price 2 and a "C" will give you price 3.

something like the following: In cell A2 you enter the item number, in B2
you enter either A, B or C. Your prices are in a data list named pricing,
with the 1st Column having the item number, Col 2:4 the various price ranges,
and in cell C2 you want to display the relevant price.
in C2 use the following formula:
=IF(B2="","",IF(A2<>"",IF(B2="A",VLOOKUP(A2,Pricing,2,FALSE),if(B2="B",VLOOKUP(A2,Pricing,3,FALSE),IF(B2="C",VLOOKUP(A2,Pricing,4,FALSE),"Enter
A B or C only")))))
 
Top