Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If specific text result,... corresponing cell info in another colu
I have the below on 2 separate data sheets, indicating if an employee is no
longer here or if a new employee. These are in column H of the data sheets. =IF($A4130,IF(ISERROR(MATCH($B413,dataID,0)),"No Longer Here",""),"") =IF(A5140,IF(ISERROR(MATCH($B514,PriorDataID,0)), "New Employee",""),"") If a no longer here result is displayed in dataprior!H413, can I get the cell value of A413 to display in another sheet, such as in cell B1 for the first incident , the next in B2, ? The no longer here, and new employee results are very random, and will be in various rows. Thanks, Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing CSV file (saved as Text) into XL as Text -- over 60 colu | Excel Discussion (Misc queries) | |||
Excel 2003 :Summing specific cells of a particular color in a colu | Excel Discussion (Misc queries) | |||
sum of 1 column if info in another = specific text | Excel Discussion (Misc queries) | |||
how to get left or right cell info after getting the result for ma | Excel Worksheet Functions | |||
Want info in a specific cell to reflect in another worksheet.. | New Users to Excel |