L
Legacy 245680
Guest
Hello
I'm a little noob with the case of excel, and i tried today to easier my excel with inputing Vlookup function.
On one sheet I have a list with names and surnames of my coworkers in one column (A), and their roles in team in another one (2). I want another cell to show the one person with a concrete role (it's "D\A"). I created something like that:
And as the correct person is in row 8, excel puts there name and surname of the person from row 30, who have other role.
Where is the error?
I'm a little noob with the case of excel, and i tried today to easier my excel with inputing Vlookup function.
On one sheet I have a list with names and surnames of my coworkers in one column (A), and their roles in team in another one (2). I want another cell to show the one person with a concrete role (it's "D\A"). I created something like that:
Code:
=VLOOKUP("D\A";A2:C34;1;TRUE)
Where is the error?