Hi all,
I wud appreciate ur assistance in getting a macro script or nested function in excel that wud lookup values in a range and return the corresponding column header value that contains the matching value:
... A B C D E
1 ore big red gel gin
2 abc acb def lek sjd
3 def sdf thr odh dfg
4 ijk abc iod wfd opq
5 lmn sef per wie dfk
6 opq sef jgh ijk djf
the formula will search for A2(abc) in the range,B2:E6 and return "big" since "abc" falls under B column header"big",so for A3(def),red(column header) wud be returned.
Thanks
Bookmarks