January 28, 2020
Hello to everybody.
I am trying to building a database for employees but i'm stuck on 2 things:
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))
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
January 28, 2020
I've tried to write a formula for that, but can't figure out the errors
=IF(AND(ISBLANK($C$7);ISBLANK($C$8);ISBLANK($C$9));" ";VLOOKUP(C7;'G.p.G. Union Security'!A1:Y2719;MATCH('G.p.G. Union Security'!B1;'G.p.G. Union Security'!$1:$1;0);FALSE);VLOOKUP(C8;'Servizi Fiduciari'!A1:Y2719;MATCH('Servizi Fiduciari'!B1;'Servizi Fiduciari'!$1:$1;0);FALSE);VLOOKUP(C9;'Dipendenti non Operativi'!A1:Y2719;MATCH('Dipendenti non Operativi'!B1;'Dipendenti non Operativi'!$1:$1;0);FALSE))
December 7, 2016
For your second problem, check out these two examples.