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($