lookup on the same row and return next value

Vote count:

0

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. enter link description here

asked 47 secs ago

Thiago Souza

1

lookup on the same row and return next value