However when using the formula suggested by sweep worked perfectly... sorry NBVC.
Cheers guys
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
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks