| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Match and update Excelsheets
Hi,
I have two 2 excel sheet. Sheet1 contains the emp# and noofaccess. Sheet2 contains the employee# and noofaccess ( more than 6 times). Based on the information from sheet1, I need to update the noofaccess (more than 6 times) column in sheet2. For example, Sheet1: emp# noofacess 123 6 234 3 345 7 456 Sheet2 emp# noofaccess(more than 6 times) 123 Yes 234 No 345 Yes 456 N/A 678 N/A COuld you please advice how to do that?. I tried the following formula. =IF(COUNTIF(Sheet4!A1:A4,A5)0,IF(B16,"Yes")), but its not working out. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Formula: Return 1st match, then 2nd match, then 3rd match | Excel Discussion (Misc queries) | |||
| Match,Update & insert new data - Please HELP! | Excel Worksheet Functions | |||
| Problem in the data of the file in the FTP after the saving of excelsheets | Excel Discussion (Misc queries) | |||
| INDEX/MATCH update limitation | New Users to Excel | |||
| Same Column on Two Sheets (Auto-update / match)? | Excel Discussion (Misc queries) | |||
Threaded Mode
