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

[Steved]

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.

 

[bj]

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)

 

[Matt Lunn]

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

 

[Roger Govier]

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)

 

[Steved]

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]

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