| Home |
| Search |
| Today's Posts |
|
#21
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell referncing
Awesome Thank You, again! I didn't know what to put in there to include the
second sheet. I didn't know I could use & for it! Thanks very much once again. "Glenn" wrote: heather wrote: Help! Trying to refernce more cells but this time in different sheets. I have revamped the formula but i can't figure it out here is sample.. http://www.savefile.com/projects/808732916 I think this is what you are looking for: =IF(A3=A2,INDEX(INDIRECT("Sheet2!"&ADDRESS(MATCH(E 2,Sheet2!$B$1:$B$40,0)+1,2)&":$B$40"), MATCH(A3,INDIRECT("Sheet2!"&ADDRESS(MATCH(E2,Sheet 2!$B$1:$B$40,0)+1,1)&":$A$40"),0)), INDEX(Sheet2!$B$1:$B$40,MATCH(A3,Sheet2!$A$1:$A$40 ,0))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referncing Rows of Filtered Data | Excel Worksheet Functions | |||
| Referncing the current cell name in an Excel MACRO | Excel Discussion (Misc queries) | |||
| How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
| Getpivotdata - referncing a data_field resulting in "REF! | Excel Worksheet Functions | |||
| concatenate cell and referncing afterwads | Excel Discussion (Misc queries) | |||
Threaded Mode
