function problem [Solved]

[neoakira]

I have a sheet containing these

NAME DDI EXT
Circle Writeup 23339595 9595
Bird Advert Times 23331515 1515
Listenor Advert Times 23333535 3535
Man Advert Times 23332525 2525
Bird Advert Circle 23334545 4545
Listenor Advert Circle 23335555 5555
Man Advert Circle 23336565 6565
23337575 7575
23338585 8585

I also have another sheet with these:

19/11/0715:53 27446875 3535 NO ANSWER 21

I would like to add a field which computes (in this case 3535) and pastes "Listenor Advert Times" in the field. Basically I want to get the third column, cross-reference it with the first sheet and return the Name accordingly.

How could I do that?

[davidh182]

VLOOKUP won't work because the lookup column is not the first column in the lookup array.

You can use MATCH to locate the row and then OFFSET to get the Name.

[neoakira]

I am able to use vlookup as the first sheet is just a reference. I managed to do what I wanted


Thanks davidh182