Home |
Search |
Today's Posts |
#1
|
|||
|
|||
naming formula
i was trying to name a fomula
<=vlookup($B6,table,3,false) now in the name the B6 is with respet to the sheet in which I originally named the formula. But I would like the name to take the B6 of the acitve sheet. I realise this can be done with a vba procedure. But is it possible to use worksheet function in this case. I hope I made mself clear. if the name is rv when I use this name in sheet1 it should refer to sheet1-B6. If i use that name in sheet2 it should refer to sheet2 B6. |
#2
|
|||
|
|||
Hi
see: http://www.xldynamic.com/source/xld.Names.html for creating local names -- Regards Frank Kabel Frankfurt, Germany R.VENKATARAMAN wrote: i was trying to name a fomula <=vlookup($B6,table,3,false) now in the name the B6 is with respet to the sheet in which I originally named the formula. But I would like the name to take the B6 of the acitve sheet. I realise this can be done with a vba procedure. But is it possible to use worksheet function in this case. I hope I made mself clear. if the name is rv when I use this name in sheet1 it should refer to sheet1-B6. If i use that name in sheet2 it should refer to sheet2 B6. |
#3
|
|||
|
|||
thanks.
I already have BOB Philips article. but it is not clear how to create < local names perhpas this functionality is not available in excel 2000. Frank Kabel wrote in message ... Hi see: http://www.xldynamic.com/source/xld.Names.html for creating local names -- Regards Frank Kabel Frankfurt, Germany R.VENKATARAMAN wrote: i was trying to name a fomula <=vlookup($B6,table,3,false) now in the name the B6 is with respet to the sheet in which I originally named the formula. But I would like the name to take the B6 of the acitve sheet. I realise this can be done with a vba procedure. But is it possible to use worksheet function in this case. I hope I made mself clear. if the name is rv when I use this name in sheet1 it should refer to sheet1-B6. If i use that name in sheet2 it should refer to sheet2 B6. |
#4
|
|||
|
|||
Hi
on thing that helps for that is Jan Karel's NameManager addin: http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.htm -- Regards Frank Kabel Frankfurt, Germany "R.VENKATARAMAN" &&& schrieb im Newsbeitrag ... thanks. I already have BOB Philips article. but it is not clear how to create < local names perhpas this functionality is not available in excel 2000. Frank Kabel wrote in message ... Hi see: http://www.xldynamic.com/source/xld.Names.html for creating local names -- Regards Frank Kabel Frankfurt, Germany R.VENKATARAMAN wrote: i was trying to name a fomula <=vlookup($B6,table,3,false) now in the name the B6 is with respet to the sheet in which I originally named the formula. But I would like the name to take the B6 of the acitve sheet. I realise this can be done with a vba procedure. But is it possible to use worksheet function in this case. I hope I made mself clear. if the name is rv when I use this name in sheet1 it should refer to sheet1-B6. If i use that name in sheet2 it should refer to sheet2 B6. |
#5
|
|||
|
|||
R.VENKATARAMAN wrote:
i was trying to name a fomula LFormula defined as: =VLOOKUP(!$B$6,Table,3,0) would cover your intent. But I don't think this is a good practice. <=vlookup($B6,table,3,false) now in the name the B6 is with respet to the sheet in which I originally named the formula. But I would like the name to take the B6 of the acitve sheet. I realise this can be done with a vba procedure. But is it possible to use worksheet function in this case. I hope I made mself clear. if the name is rv when I use this name in sheet1 it should refer to sheet1-B6. If i use that name in sheet2 it should refer to sheet2 B6. |
#6
|
|||
|
|||
thank you. I have this addin and I used with some sweating I managed to do
what i want. Frank Kabel wrote in message ... Hi on thing that helps for that is Jan Karel's NameManager addin: http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.htm -- Regards Frank Kabel Frankfurt, Germany "R.VENKATARAMAN" &&& schrieb im Newsbeitrag ... thanks. I already have BOB Philips article. but it is not clear how to create < local names perhpas this functionality is not available in excel 2000. Frank Kabel wrote in message ... Hi see: http://www.xldynamic.com/source/xld.Names.html for creating local names -- Regards Frank Kabel Frankfurt, Germany R.VENKATARAMAN wrote: i was trying to name a fomula <=vlookup($B6,table,3,false) now in the name the B6 is with respet to the sheet in which I originally named the formula. But I would like the name to take the B6 of the acitve sheet. I realise this can be done with a vba procedure. But is it possible to use worksheet function in this case. I hope I made mself clear. if the name is rv when I use this name in sheet1 it should refer to sheet1-B6. If i use that name in sheet2 it should refer to sheet2 B6. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Formula Result Correct but value in the cell is wrong | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions |