View Full Version : Solved: Formula Repeats itself??
Hoopsah
11-13-2008, 03:40 AM
Hi,
I am utilising a formula that was provided to me by XLD that worked perfectly in a previous program.
However, when I use it in this sheet it keeps giving me back the same result.
I have attached a copy to show what I mean.
MaximS
11-13-2008, 04:44 AM
vlookup formula will always bring you up the first row meeting your criteria.
MaximS
11-13-2008, 04:46 AM
please remove that post - that's browser error.
Hoopsah
11-13-2008, 04:51 AM
Sorry, your right, I will have to try and find another search method then?
Hoopsah
11-13-2008, 05:24 AM
OK,
sorry for being so dumb (It is near the end of the week)
I have changed it by putting in a counter in column A to make unique finds and now it works.
D'oh!
MaximS
11-13-2008, 05:33 AM
Unique ID is the bast idea but if you have repeating records to find you can use INDEX(MATCH) function.
Bob Phillips
11-13-2008, 06:04 AM
Try this
Hoopsah
11-13-2008, 06:07 AM
Cheers for that, I think I will stick with a unique identifier.
Thanks for your help though
Cheers
Hoops
Hoopsah
11-13-2008, 06:10 AM
Hi Bob,
you always manage to make this look easy.
That is much better than what I was trying - Thank you
Gerry
Bob Phillips
11-13-2008, 06:31 AM
Gerry,
Just noticed something you were doing on thw workbook, and using that approach we can be more efficient
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.