Register now or log in to join your professional community.
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.
Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.