| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF formula between workbooks
Hi all, does anyone know, if you have a value in A1, if you can engineer
formulas that look something like (I need two separate ones): IF(The value in A1 is in another specific workbook on a specific sheet),Show this IF(The value in A1 is in multiple worksheets),Show only a specific worksheet If this has to do with macros, please explain as much as possible, I'm macro illiterate, so a formula would be much better. Any help would be great! Thanks! Jezzica85 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF formula between workbooks
hi,
try something like this =IF('C:\DC\XCEL\[ColorIndexs.xls]Sheet1'!$C$15 = 14,14,0) you will have to use your file path. regards, FSt1 "jezzica85" wrote: Hi all, does anyone know, if you have a value in A1, if you can engineer formulas that look something like (I need two separate ones): IF(The value in A1 is in another specific workbook on a specific sheet),Show this IF(The value in A1 is in multiple worksheets),Show only a specific worksheet If this has to do with macros, please explain as much as possible, I'm macro illiterate, so a formula would be much better. Any help would be great! Thanks! Jezzica85 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| In two workbooks, how do I create a formula that will look at a o. | Excel Discussion (Misc queries) | |||
| Formula to Sum a definable range of workbooks | Excel Worksheet Functions | |||
| how can i merge 2 workbooks using a formula? | Excel Worksheet Functions | |||
Linear Mode
