Hello,
I am using V/HLookUps to pull data from a large database. The only problem is that the database contains two rows with the same value, just different formats. i.e. Row 10: "Assets" and Row 25: "Assets" in italics. Is there a way to have the VLookUp return the values for the italicized row only?
Thank you!
Short answer - no. Formatting is cosmetics, not data, excel works with data
VLOOKUP() will only pick up the 1st instance that it finds...then stop looking
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks