Hi All,

I am trying to use vlookup function, but my table array is a bit tricky. For example, my table array is B:E and col_index_num is 4 (i.e. return value in column E). However, my column A contains some specific numbers, e.g 161 and 171.

Is there any way/formula to only lookup the value that column contains 161?

Thanks a lot!