Cell value changes based on count of not null cells in range and vlookup in 2nd table

[stevemosqueda]

I want to have cell V2 count the number of not null entries in "Selection Order" table (X1:Z17) and show corresponding value found in table AF3:AV15.

I know the answer is on this site because I found it here a little over a year ago but after 3 days of searching I've found everything but the thread I was looking for. Any suggestions or a link to the elusive thread would be greatly appreciated.


- Steve

ps I can provide a sample xls to show in pictures what Im trying to describe.

 

[stevemosqueda]

I want to have cell V2 count the number of not null entries in "Selection Order" table (X1:Z17) and show corresponding value found in table AF3:AV15.

I know the answer is on this site because I found it here a little over a year ago but after 3 days of searching I've found everything but the thread I was looking for. Any suggestions or a link to the elusive thread would be greatly appreciated.


- Steve

.

n/m I used a U19 =COUNTA(X3:X18) and =VLOOKUP(U19,AF52:AG68,2) pulling data from yet another table. Trial and error works yet again,

The sheet isnt pretty but at least its back to functional.