mukesh bajaj
New Member
Hey, I have a little problem. I used the formula ,Match(), where I used Match(a1,Match():Match(),0) where I got 55:105 values form inside match functions match():match(). Now to make my formula work, I need to add column name before those (55:105) means a55:a105. I used "A"&match():"A"&match() but got the anser "a55":"a105" instead of a55:a105(means got extra inverted commas). also used concatenate but in vain. Kindly tell me.