Vlookup function not working

Use the below. file attached.

=INDEX(O:P,MATCH(C2,P:P,0),1)

lets explain why
=VLOOKUP(C2,$O$2:$P$81,16,FALSE)

this says look for the value in c2 in range O$2:$P$81 column 16 exact match
now the first thing is
O$2:$P$8 is only 2 columns so column 16 doesnt exist
v lookup looks in the first columm of the range only ie O2:081
now your column $O$2:$O$81 only contains numbers whereas c2=Multiplexer
it looks like you are trying to match c2 with column $P$2:$P$81 and get back what is in $O$2:$O$81 vlookup as it stands wont do that .you can use index/match as shown above or even
=VLOOKUP(C2,CHOOSE({1,2},$P$2:$P$81,$O$2:$O$81),2,FALSE)

If your problem is soved, please mark the thread as solved

To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save