How to use offset for specific value?

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
 
B

Bernard Liengme

=VLOOKUP(C1,A1:B6,2,FALSE)
read Help and then coma back with more questions
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to use offset for specific value? 1
How to determine the value - 19 Jan? 2
How to determine the minimum value with given condition? 2
Min Value 4
How to use index and match function for determining the value? 1
How to determine the value? 2
How to check the value? 2
How to determine whether a list contains a specific value? 4

Top