ExcelBanter - put a result into a chosen cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - put a result into a chosen cell (https://www.excelbanter.com/excel-discussion-misc-queries/87181-put-result-into-chosen-cell.html)

steph

put a result into a chosen cell

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 ?

Biff

put a result into a chosen cell

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

"steph" wrote in message
...

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 ?

All times are GMT +1. The time now is 06:27 AM.