Help with formula!

[Excel Me]

I think I need a vlookup but not sure. I am going to link two files and in one file I have text in column A and in the other I have text in columns A & B. If the value of A1 in file 1 matches any of the rows in columna A in file 2, I need it to return the corresponding row value in column B. Ex:

A A B C
1 Help Help Thanks Return Thanks if Help=Help
2 Help Dist Welcome
3 Dist Value Return
4 Value
5 Dist

 

[Jonmo1]

Welcome to the board, Yes Vlookup would be a way to go..

Try

=VLOOKUP(A1,'Other Sheet'!A:B,2,FALSE)

 

[Excel Me]

Thank you so much! For the welcome and the answer. I'm probably going to be spending a lot of time here haha. This is great.