G

#### Gandor

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)

The worksheet name is an account number.

I then use vlookups to look at B5 as the lookup value to retreive various

points of data linked to that specific account number.

The problem I have is the formula shown adove brings the sheet name in as

text and the vlookup sees it as text. I know this because when I edit the

function the returned value for the lookup value is in quotes "1234". If I

type in 1234 in a number format it works fine.

My questions is there a function I can embed the formula above into so it

returns a number format.