2 difficult questions|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hello to everybody.

I am trying to building a database for employees but i'm stuck on 2 things:

1)

If you check the file attached i have: Sheet1 (first sheet) for resume page, and the other 3 sheets are the 3 databases

in the first sheet i want to pick up infos from the other 3 databases with a simple search engine

C7 and C8 cells in Sheet1 are my "search bar" for the first and second databases (i haven't added the third yet)

the first result (cognome) is surname, on the arrow's right you will see the result if you put the employee code in the search cell, but i have to make 1 cell for every database.

So the C7's result will be in Cell E10 and C8's result in cell C11

I'd like to have all the results in the same cell (For all the three databases), but can't write the proper code with AND

I use this one: =IF(ISBLANK(C7);" ";VLOOKUP(C7;'DATABASE NAME'!A1:Y2719;MATCH('DATABASE NAMEi'!B1;'DATABASE NAME'!$1:$1;0);FALSE))

2)

The second problem seems more complex, i want to add a pic for every employee when i recall them in sheet1

for example, at each database's end i would add another column and for each line, add a sort of hyperlink that recalls the picture from hdd or website, and when i search for someone, in the first sheet display the picture on the upper/right place

Hope you will help me, i'm really stuck

Thanks in advance