Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Passing a range name as an argument to the Index Function | Excel Discussion (Misc queries) | |||
Can I HIDE cells with a conditional argument? | Excel Worksheet Functions | |||
OFFSET using ADDRESS for the reference argument | Excel Worksheet Functions | |||
how to copy the function argument box onto word | Excel Discussion (Misc queries) | |||
IF Function Help due to 7 limit | Excel Worksheet Functions |