your description of your data and the formula do not agree.

Let me rewrite what you have said
two sheets of data
on one sheet (sheet2!)you have a comparison cell to look up from
on a second sheet ('From charters") you have a table of data

you have an equaiton on sheet2
one guess is that your equation should be
=VLOOKUP($A$3,'From Charters'!$A$1:$I$300,3,0)

but if your comparison data is found on C7 and your wanted data is found on
C13 you probably need Hlookup instead
=Hlookup($A$#,'From Charters'!$C$!:$I$300,7,0)

"Steved" wrote:

Hello from steved

On the sheet1 which I have named From Charters I reqire data from Cell C13.
On Sheet2 I have =VLOOKUP('From Charters'!$A$3,$A$1:$I$300,3,0)

Sheet2 A3 = City - Panm
Sheet Named From Charters C7 = City - Panm
Sheet Named From Charters C13 is the data I require.
What Am I doing wrong for it to give me #N/A please.

Thankyou.