Steved

Posts: n/a

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Forget SUMIF, COUNTIF and VLOOKUP	Pierre Leclerc	Excel Worksheet Functions	16	April 27th 23 11:51 AM
lookup combine vlookup with hlookup	Doug	Excel Worksheet Functions	2	April 23rd 23 11:42 AM
Vlookup and Hlookup	Phlogiston2312	Excel Worksheet Functions	1	April 21st 05 04:59 PM
Vlookup and Hlookup	Phlogiston2312	Excel Worksheet Functions	2	April 20th 05 05:09 PM
Can vlookup or hlookup look to other worksheets within a workbook.	flgc54	Excel Worksheet Functions	1	March 12th 05 12:31 AM

All times are GMT +1. The time now is 04:56 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us