Hi
From A1:G11, this data was given. Based on this information, is it possible to a formula in col H to lookup the country code in row 1?
thanks
Hi
From A1:G11, this data was given. Based on this information, is it possible to a formula in col H to lookup the country code in row 1?
thanks
Last edited by Pepe Le Mokko; 04-01-2020 at 02:24 AM. Reason: Shortened title
at H6
=INDEX($A$1:$F$1,SUMPRODUCT((B6:F6=1)*(COLUMN(B6:F6))))
copy down
That's amazing! Thank you so much for your quick response and help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks