LinkBack URL
About LinkBacks
he's not always right
(ok, yes he is... well alright 99.9% of the time... though I guess Ron would argue otherwise based on our little INDEX Volatile chat the other day)
he's not always right
(ok, yes he is... well alright 99.9% of the time... though I guess Ron would argue otherwise based on our little INDEX Volatile chat the other day)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Thanks for the help guys - but it doesn't quite work.
I have attached the spreadheet with what I have done and the suggested formula by NBVC - but it just comes out as 0 for all of them.
Last edited by Back2Basics; 02-04-2009 at 08:23 AM.
However when using the formula suggested by sweep worked perfectly... sorry NBVC.
Cheers guys
If that's the case you have setup the MATCH incorrectly... the MATCH range should be the left most column of your VLOOKUP range only
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks