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.