Originally Posted by boopathiraja Try Formula: =HLOOKUP(B$1,'Lev1'!$C$8:$N$13,MATCH($A2,'Lev1'!$B$8:$B$13,0)) nice formula
=HLOOKUP(B$1,'Lev1'!$C$8:$N$13,MATCH($A2,'Lev1'!$B$8:$B$13,0))
Samba Say thanks to those who have helped you by clicking Add Reputation star.
Thanks Siva Originally Posted by nflsales nice formula
☚ Click ★ just below left if it helps, Boo?ath?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Forum Rules
Bookmarks