Ok so in the attached sheet, column T and U have VLOOKUPS in them but neither work.
They look at the corresponding column B value. The value is in there and looks at another cell. e.g B4 get's it's value from B3.
If i type in to B4 what's already in there, e.g 1100, the look up works.
Why is this? What is wrong with using a value generated by a formula?
The Company Codes on Profit & CC sheet are numbers whereas on your Journal sheet they are text (Col B) - you must coerce Col B in the VLOOKUP such that the data type matches, eg:
Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Exactly what i needed!
Thanks mate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks