Hi I want to put a look up formula as follows: =HLOOKUP(A$3,Datasheet!$A$1:$B$10,2,FALSE)
However I want the formula to return the exact cell reference, say,B7 instead of returning the absolute value, say, 25. How can this be done?
Thanks in advance for your help
However I want the formula to return the exact cell reference, say,B7 instead of returning the absolute value, say, 25. How can this be done?
Thanks in advance for your help