#1   Report Post  
Posted to microsoft.public.excel.misc
Elliott
 
Posts: n/a
Default Lookup and offset


I have a problem with a workwook and would like to use the lookup along
side the offset function.

I want my returning answer to be a number of columns and rows away from
the cell I am looking up rather than say 3 columns along.

Is this possible.

Any help would be great.


--
Elliott
------------------------------------------------------------------------
Elliott's Profile: http://www.excelforum.com/member.php...o&userid=31873
View this thread: http://www.excelforum.com/showthread...hreadid=516004

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
offset a lookup in excel Inni17 Excel Worksheet Functions 1 January 17th 06 03:56 PM
Lookup, Index or Offset reno Excel Discussion (Misc queries) 1 October 6th 05 12:06 AM
lookup with offset? GEORGIA Excel Worksheet Functions 2 August 17th 05 09:28 PM
lookup, index, match, offset, etc. [email protected] Excel Worksheet Functions 2 January 3rd 05 08:51 PM
Ranges with in a LOOKUP Elijah Excel Worksheet Functions 2 November 23rd 04 10:40 AM


All times are GMT +1. The time now is 04:22 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"