Vlookup not working
Hey guys, I'm trying to use macros to do a vlookup in another sheet.
So you click on the time button and it sets up the time based on the time you put for the first cell in that list. Then you click the duration button and its supposed to vlookup the time values in another sheet and return a value, but it only gets the fourth row right and misses the first 3 vlookups.
Any Ideas?
new pro.xlsm
This may be a novice answer to your problem, but if you change the formulas in 'Power Profile'!C to be rounded to 5 decimals and then do the same in 'Mission Schedule'!B it the macro picks up the values for the first 3 Vlookups. I don't think the Vlookup was good at comparing these values. Someone with more expertise in Excel can probably give a better explanation of why, but this solves your problem.
Your 'time as text' column is not showing you the true value.
If you use a 'watch' on 'Arg1' in the VB editor, and then step through the code, you will see that the value that it picks up is NOT the same as is displayed in text in the cell.
I would think you would be better working directly from the date/times themselves.
If you find the response helpful please click the scales in the blue bar above and rate it
If you don't like the response, don't bother with the scales, they are not for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks