For example, let say you have row number in A3:
=VLOOKUP(A2,$M$2:INDEX($P$1:$P$1000,A3),2,FALSE)
For example, let say you have row number in A3:
=VLOOKUP(A2,$M$2:INDEX($P$1:$P$1000,A3),2,FALSE)
Never use Merged Cells in Excel
![]()
=vlookup(a2,indirect("$m$2:$p$"&a3),2,false)
If I have helped, please click the star below.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks