Hui, I just looked at the documentation of MATCH and INDEX and I could figured it out. Its a matter of if and else conditions and checking for ISNA function. Thanks for the direction my problem is solved...
Hui.. This is awesome. Very nice and works great. Thanks for your deailed explanation too. You can really do wonders with Excel.
You solved my problem. Now if for some reason the Value in A1 on Sheet does not match with the array from A1 to A10 on Sheet2 , the cell value is displaying as...
Hi Chandu,
The way you structured the Excel information on your web site is very impressive. Actually I was referred by on of my friend from Visakhapatnam. Nice to know your work on Excel. It's a one place for all Excel related problems.
Well.. I am also coming to you with a problem...