Hello F,
welcome to the forum. Try this for "Second":Formula:
{=IFERROR(SMALL(IF(A2=Sheet2!A:A,Sheet2!B:B,""),2),"")}
And this for "Third":Formula:
{=IFERROR(SMALL(IF(A2=Sheet2!A:A,Sheet2!B:B,""),3),"")}
Let me know if it works.
Cheers
Hello F,
welcome to the forum. Try this for "Second":Formula:
{=IFERROR(SMALL(IF(A2=Sheet2!A:A,Sheet2!B:B,""),2),"")}
And this for "Third":Formula:
{=IFERROR(SMALL(IF(A2=Sheet2!A:A,Sheet2!B:B,""),3),"")}
Let me know if it works.
Cheers
<-- If you're happy & you know it...click the star.:-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks