ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Offset Function (https://www.excelbanter.com/excel-worksheet-functions/87317-offset-function.html)

birdsting
Offset Function
 
May I know how to use the offset function with lookup or index/match functions. Please show me an example with thanks.

starguy
Offset Function
 

visit this page
http://www.cpearson.com/excel/lookups.htm#ClosestMatch


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=539766


All times are GMT +1. The time now is 12:18 PM.

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