Uhmn! I haven't seen this one before buys.
See the attached and look in Sheet1!D30:D37 returning #N/A as it can't locate the row index for the value specified. I've spent several minutes on this one and I don't seem to make any head-way.
Am I missing something? I'd prefer if leave the exact match variable, as if we leave out the zero (0) variable it will give me the wrong result.
Thanks guys,
Last edited by ron2k_1; 05-31-2011 at 11:16 AM.
Ron
Knowledge is knowing that a tomato and pepper are fruits. Wisdom is knowing whether to put these in a fruit salad
Kindly
[1] Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
[2] Mark your post [SOLVED] if it has been answered satisfactorily by editing your original post in advanced mode.
[3] Thank (using the little scale) those that provided useful help; its nice and its very well appreciated
Hi,
It's a rounding issue due to how XL works with numbers under the hood.
If you change the formula in D30 to this, it will return Clerk 6:
Please Login or Register to view this content.
Because of the calculations made in column M, Excel has rounding issue quirks ... try instead:
=PROPER(INDEX(Sheet2!$F$4:$F$170,MATCH(ROUND(C30,1),Sheet2!$O$4:$O$170,0)))
copied down.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Weird, never had the pleasure of meeting that before! I guess I'll be more careful and use those reassuring-value functions in the future.
Thanks mates,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks