Hi, I am using Vlookup, but I have a problem, I have 2 identical items within my range.
If I have as follows:
IC Prov 145.00
IC Prov 150.00
My formula is as follows:
How can I modify the formula to ignore the first "IC Prov" and return the value on the second "IC Prov" without having to change the range?Please Login or Register to view this content.
Thanks
Bookmarks