Help with MATCH and OFFSET.

[proepert]

I attached a sample workbook.

The user enters a string in A2. Columns E and F have the data.

In B2, I want to put the value that is located in the F data column next to the string in the E data column. I made two lists, but can't figure out the formula for the B2 cell.

I hope this is not in the wrong forum, and I hope I explained the issue so you can understand.
Thanks for helping me.

Excel 2000

[NBVC]

Try:

=VLOOKUP(A2,E:F,2,FALSE)

[proepert]

Oh thanks so much. Could you please be so kind to explain the the formula to me?

[NBVC]

Best to have a look at Excel's help file on VLOOKUP... it explains the formula well with examples.

Have a look here:

http://www.techonthenet.com/excel/formulas/vlookup.php

and

http://www.contextures.com/xlfunctions02.html

for more help and advanced uses...