combining different formulas with vlookup

[wbfd25]

alright guys and gals i need some help with a formula i want to search a list of people which is set up as such colA last name, colB first name, ColC office num, colD fax num, colE home num, colF cell num ect. this list is located on sheet 2. i would like my users to be able to search this list on sheet 1 by just typing in their last name in a cell and first three in a different cell. i would like it to match the two and return a name in the name cell which will be used as a reference for other vlookup formulas to locate the numbers that go with that name....i have tried a lot of different way and have yet to get one that works for what i need it to do as there is also people with the same last name. im sorry i do not have an attatched sheet to help you help me. thank you again

 

[kevatarvind]

pls post some sample data with desired result

 

[wbfd25]

this is the formula i have so far that allows me to search for a last name an return a first name =IF(ISNA(VLOOKUP(TRIM($D$4),Sheet2!$1:$65536,1,FALSE)),"",(VLOOKUP(TRIM($D$4),Sheet2!$1:$65536,2,FALSE)))

 

[wbfd25]

i have a sheet however i cannot figure out how to post it here for the life of me lol

 

[Aladin Akyurek]

i have a sheet however i cannot figure out how to post it here for the life of me lol

You just need to specify:

1. the look up values and the cells in which they are located;
2. the table area where they must be looked up (searched for).