Try this.Formula:
=INDEX(E12:$E$33,MATCH(D11,D12:$D$33,0))
if it doesn't exist again it will give #N/A you can use this formula if you prefer to return nothing
Formula:
=IFERROR(INDEX(E12:$E$33,MATCH(D11,D12:$D$33,0)),"")
Try this.Formula:
=INDEX(E12:$E$33,MATCH(D11,D12:$D$33,0))
if it doesn't exist again it will give #N/A you can use this formula if you prefer to return nothing
Formula:
=IFERROR(INDEX(E12:$E$33,MATCH(D11,D12:$D$33,0)),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks