How to use offset for specific value?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know how to use offset for specific value? such as
Under column A, there is a list of value.
Under column B, there is a list of value.
In cell C1, I input any value listed under the column A, for example "xxx"
is found under cell A6,
In cell D1, return the value "yyy", which is found under cell B6.

Does anyone have any suggestion?
Thank you in advance
Eric Choi
 
=VLOOKUP(C1,A1:B6,2,FALSE)
read Help and then coma back with more questions
best wishes
 
Back
Top