This should be pretty easy but I cant find it:
I would like to lookup the same name across several columns (about 20) and return the value of a set column for each of the found iterations.
When there is no match, nothing should be returned.
The number of Rows are approx 500.
Typically the same name appears only 20 or 30 times across the entire array. So ideally, the results should be displayed on 20 or 30 rows, not on 500 rows...
I attach a sample. Hope it clarifies.
Thanks for your help.
Bookmarks