Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Steved
 
Posts: n/a
Default One more Argument.

Hello from Stevecd

In the sheet I've called From Charters I have a twelve month product which I
call period .1 , period .2 and so on. In the below formula how can I ask it
to also look up period.1 Please.

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

Thankyou.
  #2   Report Post  
Andy Wiggins
 
Posts: n/a
Default

Have you looked in Excel's help? It's full of useful advice and guidance for
your sort of problem.

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"Steved" wrote in message
...
Hello from Stevecd

In the sheet I've called From Charters I have a twelve month product which

I
call period .1 , period .2 and so on. In the below formula how can I ask

it
to also look up period.1 Please.

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

Thankyou.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Passing a range name as an argument to the Index Function Michael Sharpe Excel Discussion (Misc queries) 3 September 5th 12 01:33 PM
Can I HIDE cells with a conditional argument? Bob the Builder Excel Worksheet Functions 2 July 22nd 05 10:30 AM
OFFSET using ADDRESS for the reference argument TRE Excel Worksheet Functions 1 June 17th 05 01:33 PM
how to copy the function argument box onto word Hannibal Excel Discussion (Misc queries) 1 April 13th 05 09:24 PM
IF Function Help due to 7 limit John F Excel Worksheet Functions 11 January 12th 05 10:07 PM


All times are GMT +1. The time now is 07:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"