How to use offset for specific value?

E

Eric

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

VBA Coding Help for Beginner 0
How to use offset for specific value? 1
Drop down list control value in vba 2
How to Create an S-Curve from Custom Field? 0
Word macro that can call cells out of Excel for a find and replace 0
How to use index and match function for determining the value? 1
Min Value 4
How to determine the value - 19 Jan? 2

Top