| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula between worksheet tabs
I have two tabs in a workbook. I have accounts in column A on worksheet 1
(editorial). I want to search the account column A on worksheet 2 (planning_nodes) and if the account matches account from worksheet 1, I want it to bring back the data from column C in worksheet 2 (planning_nodes). I tried using an If formula. =IF(A2=planning_nodes!A:A,planning_nodes!C:C,"") This formula is not working. Is there a better formula? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to name worksheet tabs using a cell within the worksheet? | Excel Discussion (Misc queries) | |||
| Formula needs to include several worksheet tabs in one workbook | Excel Discussion (Misc queries) | |||
| Can Excel worksheet tabs be relocated above the worksheet? | Excel Discussion (Misc queries) | |||
| Worksheet tabs | Excel Discussion (Misc queries) | |||
| Indirect formula using Data Validation List of Worksheet Tabs | Excel Worksheet Functions | |||
Threaded Mode
