Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
contents embed
On my first sheet1 there are names of employees into the column B.
On the second sheet2 I need type in keys into the column A, than column B needs recognize key and automatic typs in name of employee with first name and name. How can I to do it? Can somebody help me and solve this problem? As always I am greatful for your help, Mery |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
contents embed
You need to have a unique ID number for each employee which can be
listed in Sheet1 column A along with the names in column B. Then when you enter an ID number into A1 (say) of Sheet2, you can put this formula in B1: =IF(A1="","",IF(ISNA(VLOOKUP(A1,Sheet1!A:B,2,0))," n/ a",VLOOKUP(A1,Sheet1!A:B,2,0)) This will return the name if the ID number exists, otherwise it will return the message "n/a". Hope this helps. Pete On Apr 28, 10:49*am, Mery wrote: On my first sheet1 there are names of employees into the column B. On the second sheet2 I need type in keys into the column A, than column B needs recognize key and automatic typs in *name of employee *with *first name and name. How can I to do it? Can somebody help me and solve this problem? As always I am greatful for your help, Mery |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
contents embed
I am very happy ,problem solved and I can continue work,
once again, thanks verry,very much Regards, Mery Korisnik "Pete_UK" napisao je: You need to have a unique ID number for each employee which can be listed in Sheet1 column A along with the names in column B. Then when you enter an ID number into A1 (say) of Sheet2, you can put this formula in B1: =IF(A1="","",IF(ISNA(VLOOKUP(A1,Sheet1!A:B,2,0))," n/ a",VLOOKUP(A1,Sheet1!A:B,2,0)) This will return the name if the ID number exists, otherwise it will return the message "n/a". Hope this helps. Pete On Apr 28, 10:49 am, Mery wrote: On my first sheet1 there are names of employees into the column B. On the second sheet2 I need type in keys into the column A, than column B needs recognize key and automatic typs in name of employee with first name and name. How can I to do it? Can somebody help me and solve this problem? As always I am greatful for your help, Mery |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
contents embed
You're welcome, Mery - thanks for feeding back.
Pete On Apr 28, 12:07*pm, Mery wrote: I am very happy ,problem solved and I can continue work, once again, thanks verry,very much Regards, Mery |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EMBED | Excel Discussion (Misc queries) | |||
compare the contents of one range of cells with the contents of a. | Excel Discussion (Misc queries) | |||
EMBED | Charts and Charting in Excel | |||
Macro to remove contents of cell and move all other contents up one row | Excel Discussion (Misc queries) | |||
Embed a US MAP | Charts and Charting in Excel |