If a cell matches a range on another worksheet -- display value of cell in next column

Hi all,

So, this probably isn't a very complicated problem, but I am not so great at excel.

The problem I am working on:

1. Try to match the value of a cell to another cell on a different worksheet.
2. Display the value of the cell in the column next to the match (the one on a different worksheet).

This is as far as I've gotten

=IF(ISNA(MATCH(A14,Sheet1!$E$2:$E$4478,0)),"N","Y")

Basically, it will let me know if there is a match or not. What I want it to do now, is display the value of the column next to it (same row). This would be column F on Sheet1.

My brain is on the verge of exploding so any help would be greatly appreciated!

Originally Posted by Kaper

try:

Formula:

Please Login or Register  to view this content.

or

Formula:

Please Login or Register  to view this content.

Works perfectly! Thanks so much!