Formula with a vlookup

[jhitebav]

HI all, I am looking for a formula or code to try taking out some manual work that I am having to do.

I have a spreadsheet with values for people's name that I have to enter in cell B2, in cell A2 I have a string of text/numbers.

I usually go to cell A2 and find either the employee id or employee system name, then I go to a table and see this information and then match up the name from this table to the employee's from either the id or system name.

What I am hoping for is a formula that can search the text/number in cell A2 against the table and return the name of the emplpyee, what makes this more difficult is that it needs to search in the table for either the employee id or employee system id then return the employee name like how you would use a vlookup.

Any help would be much appreciated.

 

[bbott]

Welcome to the board.

Can you provide a small sample of your data table: You could probably do something like:

=IFERROR(VLOOKUP 1, VLOOKUP 2)

 

[jhitebav]

Hi below is my first sheet, with column A with the values, Column B is where I need to enter the names

Description (Column A) Who? (Column B)
Xmas PERIOD 5 701684
Xmas PERIOD 5 701704
CHRISID 40100315
CHRISID 40100315

Below is a second sheet where I match the data to the above sheet. System id is column a, employee id is column b and surname is columns c.

system id employee ID Surname
123456 40067805 A
701679 40138240 B
701684 40140765 C
125969 40100315 E
150696 40008867 F
701430 40042445 G
701581 40096086 H
701613 40033335 I
701628 40108646 J
701652 40114905 K
701681 40140322 L
701682 40140323 M
701699 40143661 N
701704 40145627 O
701716 40279571 P