Would it be this?
=IFERROR(LOOKUP(2,1/((IF($B3<>"",B3,A3)='Raw data'!$A$2:$A$100)*(D$1='Raw data'!$D$2:$D$100)),'Raw data'!$B$2:$B$100),"")
Would it be this?
=IFERROR(LOOKUP(2,1/((IF($B3<>"",B3,A3)='Raw data'!$A$2:$A$100)*(D$1='Raw data'!$D$2:$D$100)),'Raw data'!$B$2:$B$100),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks