Want to make a reference from specified cell, but from another column

[magnusfock]

Hello,

in this example I have manually put in references in b10,b11,b12,b13.

For e.g. in cell b10 I have put in =b3. Now I would really like if the cell d10 would show the value from =m3.

Then in b11, after manually put in =b5, I would like the cell d11 to show the value from =m5

Since all references in the B-column is put in manually, I dont know how to get a formula to put in the value from the same row but instead from the M-column.

Sorry if I did not make my self clear enough.

I have attached a worksheet.

Kind Regards
Magnus

[modytrane]

use this in D10 and copy down.

=VLOOKUP(B10,B3:M6,12,FALSE)

[magnusfock]

Thank you very much!

In this case with about 1000 rows in the worksheet, there will be multiple examples of whats in b10 ("alfa" in this sheet).

I tried this. =VLOOKUP(B1170,$B$3:M1170,12,false)
It found the value, but the first one and not the "right" one.

Can I make sure it chooses the one on the last row rather than the opposite?

[peterrc]

Hi magnusfock,

In order to copy down I think Modytrane's formula should be:-
=VLOOKUP(B10,$B$3:$M$6,12,FALSE)

Regards

peterrc

[peterrc]

Hi magnusfock,

In order to copy down I think Modytrane's formula should be:-
=VLOOKUP(B10,$B$3:$M$6,12,FALSE)

Regards

peterrc