Gents, I feel the formula I want is incredible simple but I have tried offset, index and match and was not able to get it.

My problem:


----------[Column A]--[Column B]---[Column C]--[Column D]

row 1-------164F------------1------------- 164F--------formula 1
row 2-------1638------------4--------------1638-------formula 2


formula 1 = I want to look the value in the column C and return the value from the right column referent to the value looked, like if the value of column C is 164F, it will search the row for the left and return the value in column B =1, value which is at the right of the value looked. I'm working on a table for referencing. I have attached an example.look on same row.xlsx