| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look up functions
Is there a formula that will look up the value in cell B1 in a sheet named
AE1 and copy the value into cell O3 in sheet named Data? I have several sheets and values I need copied. I have tried making the cell O3 in the Data sheet =AE1!B1 but I do not always have a sheet named AE1 for the cell to refer to. I need to be able to copy the Data sheet into a workbook and have it populate automatically and if a sheet is not found the return a value of 0 to that cell. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Look up functions
One way: =IF(ISERROR(AE1!A1),0,AE1!A1) -- JBeaucaire ------------------------------------------------------------------------ JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=46793 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Look up functions
Works great, but can I copy into a new workbook with out it referencing the
workbook it came out of? "JBeaucaire" wrote: One way: =IF(ISERROR(AE1!A1),0,AE1!A1) -- JBeaucaire ------------------------------------------------------------------------ JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=46793 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Look up functions
Copy/Paste would add the original workbook name. Why copy? Just write new versions for the new workbook. -- JBeaucaire ------------------------------------------------------------------------ JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=46793 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple functions, conditional functions | Excel Worksheet Functions | |||
| How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
| formula/functions for average and if functions | Excel Worksheet Functions | |||
| efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
| Nesting functions in the functions dialog box | Excel Worksheet Functions | |||
Linear Mode
