| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula between worksheet tabs
Try this:
=VLOOKUP(A2,planning_nodes!A:C,3,0) -- Biff Microsoft Excel MVP "Sam" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula between worksheet tabs
Try
=VLOOKUP(A2,'Planning nodes'!A:C,3,FALSE) Mike "Sam" wrote: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula between worksheet tabs
That worked. Thanks.
"Mike H" wrote: Try =VLOOKUP(A2,'Planning nodes'!A:C,3,FALSE) Mike "Sam" wrote: 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 |
| Reply |
| 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 | |||
Linear Mode
