On 11 Apr, 22:48, anon wrote:
Hi,

I'm sure someone can help but i'm not clear what you are asking.

Are you looking to lookup a value in a range and then return a value
in another column on the same row where it was found?

Eg lookup K12 in a2:f11. If the value of K12 is found in a7 return the
value in b7

If not please try and explain again.

look K12 in range(C2:C11) and SS which is in cell F2 in range(A2:A11)
then bring value from range(B2:B11)
the value should come 50 as if you see above table in row 2 we have SS
in cell A2 and K12 in cell C2 so formula should pick cell B2 value
which is 50. Basically with vlookup you lookup on value and then bring
the answer but i want some formula which should lookup 2 values same
time and then bring the result. i hope you understand what i am tring
to say.