ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Lookup and offset (https://www.excelbanter.com/excel-discussion-misc-queries/73586-lookup-offset.html)

Elliott

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



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com