Vlookup N/A error

1. VLOOKUP function takes on the following syntax: Syntax: VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]).
   You have not defined the col_index_num. Which column do you want to lookup in Table1? "KN", "Price", "D-Line" or "HEAD"?
2. Your values in column I are texts, not numbers, while the values in "Length" column in Table 1 are numbers - use VALUE function to convert to numbers

Revised formula:=IF(AND(J2=0,C2="r",I2>="9.5"),VLOOKUP(VALUE(I2),Table1[#All],5,FALSE),0)

5 to lookup for values in "HEAD", 4 for "D-Line" etc.

attach the file with the desired result

Hi Joseph,

Thanks so much for your reply. I am trying to reference the "Price" column (3) in Table 1. I have uploaded a new workbook where I have put in your formula and also added the desired results in the column next door. Unfortunately, when I use your formula I don't get my desired result. I would be really appreciative of any help you can offer me here, thanks

Originally Posted by CARACALLA

attach the file with the desired result

I have uploaded a new file with a desired result column, thanks

Remove the brackets in "9.5" if you have converted the values in column I to numbers.

And you do not need the VALUE in VALUE(I2) as well, just I2.

Full formula:=IF(AND(J2=0,C2="r",I2>=9.5),VLOOKUP(I2,Table1[#All],3,FALSE),0)

Thanks Ali, yes quotation marks, not brackets.

Thank you so much Ali and Joseph, that fixed it!!!