Hi Expert,
Need your expertise for given range in 7 cells that has numbers and if matches in eight cell, write the results
e,g
if in a row A1:G1 has :
1,2,3,4,5,6,7 numbers and H1 has say number 4, I wish to have function to mach and write 4 in cell I1
I have tried in cell I1 function =Match(H1,A1:G1,0) gives me incorrect results
Please help
Thanks
Karnik
Bookmarks