How to nest Offset Function in Vlookup formula?

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

by Firas Shahadi , Training And Development Director , Muhayal Assir National Hospital

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.

how can i use vlookup formula in reverse order i.e. right to left in ms excel?
Top Answer: Please use INDEX+MATCH See More

Answers (2)
Who can give us the high advanced use for VLOOKUP formula?
Top Answer: VLOOKUP Formula - is a unique formula when you want to get your report or consolidated it, its makes you ... See More

Answers (6)
What is the simple way to learn Vlookup Formula?
Top Answer: It's pretty easy to learn.... http://www.spreadsheetsmadeeasy.com/how-use-vlo ... See More

Answers (1)
What is vlookup formula?
Top Answer: It searches the other related information to a very similar data in another database with the considering ... See More

Answers (1)

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.