#N/A using vlookup in excel

Question

I'm not sure why I get #N/A here. I a trying to get the retrieve the number of pages for paper 360.

Answer 1

Can you try to see if your A column has the "360" value? Maybe if you try to change the value of 360 in F2 (C/L) to 5, the value of 10 will be returned.

Answer 2

Use:

=IFNA(INDEX(A:A,MATCH(F3,B:B,0)),"Value does not excist")

Answer 3

Don't worry I solved it. I realized vlookup looks in the first column of my table, so I swapped the order of columns in my table and that fixed it.