Ask Your Question

vlookup, data on another sheet [closed]

asked 2014-03-24 18:29:00 +0200

Glitter gravatar image

updated 2014-03-25 07:10:35 +0200

Hello! I have column B on sheet1, and name columan A) and surname (columns B) on sheet2. On column B3 on sheet1 I have to place surnane, I found by vlookup function, so that I search the surname which is in the same row as name in A3, sheet2.

On sheet1, in A column, I have names. On column B I should place surnames, but using vlookup from the sheet2.

Please, can someone help me to write the right syntaks? Thanks in advance!

Hello! Would it be right sth like: =vlookup($A2; $Sheet2:$A2:$sheet2:b15; 2)

I tried like this bt get #NAME? error

Please, can someone help?

Many thanks!!! Please ,would it be sth like: =vlookup($

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-20 15:37:21.488112

2 Answers

Sort by » oldest newest most voted

answered 2014-03-24 22:04:26 +0200

lactea gravatar image

updated 2014-03-25 09:29:23 +0200

I am not sure if I got you correctely, nevertheless, I've tried. What about this approach? VLookup.ods Change NameA to NameB, NameC etc. to get the respective surename.

Plus, I have seen this solution somewhere. It does not belong to me, so all credits to the creator. dynValidation2.3.ods

Edit: @Glitter has modified the question, so I have updated my file. Be aware that every name has to be unique to get correct results. VLookup.ods

Please mark your edit next time as it is hard to follow up!

edit flag offensive delete link more


@lactea - now rereading the question it seems to be simpler than I initially thought. So +1 to your answer.

mahfiaz gravatar imagemahfiaz ( 2014-03-24 23:42:34 +0200 )edit

answered 2014-03-24 18:53:57 +0200

mahfiaz gravatar image

VLOOKUP() works only on continuous ranges on one page, AFAIK.

What would help you is a combination of MATCH() and OFFSET().

edit flag offensive delete link more


Vlookup() works on different sheets, FYI

lotofgenius gravatar imagelotofgenius ( 2019-01-21 07:45:11 +0200 )edit

Question Tools

1 follower


Asked: 2014-03-24 18:29:00 +0200

Seen: 3,032 times

Last updated: Mar 25 '14