put a result into a chosen cell

S

steph

I have this table:

A B
1 45645 22
2 58423 25
3 ..... ..

Is there any formula to obtain this: cell A45645= 22, cell A58423=25, etc?
If possible without VBA ?
 
B

Biff

Hi!

You didn't provide a whole lot of detail but try one of these:

=SUMIF(A1:A3,45645,B1:B3)

=VLOOKUP(45645.A1:B3,2,0)

Better to use cells to hold the criteria:

C1 = 45645

=SUMIF(A1:A3,C1,B1:B3)

=VLOOKUP(C1.A1:B3,2,0)

Biff
 
Top