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.