I've tried Sumproduct, SumIf, Vlookup and Hlookup.
 

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.

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.

Not sure I fully understand what you're trying to do but just give this a try

=VLOOKUP($A$3,'From Charters'!$A$1:$I$300,3,0)

Thanks,
Matt

"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.

The actual data you require is below the cell containing the city name.
Are your cities listed across row C in the sheet 'From Charters'?
If so, you need HLOOKUP, not VLOOKUP and your range would start with $A but
would need to use row 7 since you say Panm is in C7

Try
=HLOOKUP($A$3,'From Charters'!$A$7:$I$300,6,0)

--
Regards
Roger Govier
"Steved" wrote in message
...
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.

Hello Roger from Steved

Roger thankyou for explaning what I needed to do. ie starting in row 7, I
would not
have realised what effect row 7 has but thanks to you I've learnt today.

Cheers.

"Roger Govier" wrote:


The actual data you require is below the cell containing the city name.
Are your cities listed across row C in the sheet 'From Charters'?
If so, you need HLOOKUP, not VLOOKUP and your range would start with $A but
would need to use row 7 since you say Panm is in C7

Try
=HLOOKUP($A$3,'From Charters'!$A$7:$I$300,6,0)

--
Regards
Roger Govier
"Steved" wrote in message
...
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.

You're welcome. Glad to hear you have now sorted it out.

--
Regards
Roger Govier
"Steved" wrote in message
...
Hello Roger from Steved

Roger thankyou for explaning what I needed to do. ie starting in row 7, I
would not
have realised what effect row 7 has but thanks to you I've learnt today.

Cheers.

"Roger Govier" wrote:


The actual data you require is below the cell containing the city name.
Are your cities listed across row C in the sheet 'From Charters'?
If so, you need HLOOKUP, not VLOOKUP and your range would start with $A
but
would need to use row 7 since you say Panm is in C7

Try
=HLOOKUP($A$3,'From Charters'!$A$7:$I$300,6,0)

--
Regards
Roger Govier
"Steved" wrote in message
...
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.