Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How to nest Offset Function in Vlookup formula?

Accounting Microsoft Excel Vlookup Finance
user-image
Question added by muhammaad Asim , Accountant - Receivable/Collection , EDCH (Business Unit of Etisalat)
Date Posted: 2017/01/03
Upvote (0) Views (4) Followers (1) Answers (1) Report Question
Write an Answer
Register now or log in to answer.
Firas Shahadi
by Firas Shahadi , Human Resources Director , SAUDI UNION

you can nest in to define a dynamic range.

one possible option

=VLOOKUP(A1,OFFSET(B1,0,0,COUNT(B:B),2)

this will make a dynamic range of 2 columns 

 

we are using it a lot when there is a dynamic range.

Write Your Answer
More Questions Like This