Lookup.png
Hi,
In column B is the result that i need. What is the formula in column B that can lookup the title in cells D2 to F2? Column A is the condition/criteria.
Thanks.
Lookup.png
Hi,
In column B is the result that i need. What is the formula in column B that can lookup the title in cells D2 to F2? Column A is the condition/criteria.
Thanks.
Last edited by babychai; 06-10-2020 at 11:54 AM.
In B2 copied down
=INDEX($D$2:$F$2,AGGREGATE(15,6,(COLUMN($D$2:$F$2)-COLUMN($D$2)+1)/($D$3:$F$6=A4),1))
Fluff13, thank you. work great^^
You're welcome & thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks