I'm having trouble adapting this formula to my spreadsheet and I'm not sure I'm doing the right thing. I'd really appreciate some help.
I have two tables stacked on top of each other; the number of entries in each table changes from month to month, which is why I need a dynamic vlookup.
In Column A I have a bunch of titles. The first table is headed "Yes" (Cell A1) and the second table is headed "Possible" (for this month, Cell A42, but it will be a different row next month).
In Column B I have a bunch of values (the number of times the titles were counted that month).
As an example:
A B
Yes 10
e 5
d 4
f 1
Possible 12
s 8
e 3
r 1
I want the Vlookup to start its range right after the word Possible, to find a particular title from Column A, and to report the number of titles for that month (so the number in Column B). So for example, I'd be trying to find the value 3 if I were looking up title "e."
I've modified a formula I found in an existing thread (here) to:
=VLOOKUP(L10,INDEX(A:B,MATCH(L4,A:B,0)+1):L4,2,0)
Where L10 holds name of the particular title I'm looking up (eg "e" from the example above; this title may or may not be in the first table), AB are obviously the columns contaning all my data, and L4 contains the word Possible (separately to column A becuase I can't identify the cell within Column A itself as it changes every month and I don't want people to have to search for it).
I currently get a value of #N/A. :-(
I am very new to this and clearly don't know what I'm doing! I'd really appreciate some help.
[Also: very sorry that I posted this in the wrong thread earlier.]
Bookmarks