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.