I use excel to figure out employee hours and wages using Vlookup. The problem is the table array transposes as copy the formula over to adjecent cells. my table array is a3:d2167 but as i copy it over and down the table transposes aswell. ie b4:e2168 is there a fix for this that i am overlooking?
Hello
$ sign
a$3:d$2167
Contributors to this forum do not get paid. They give their valuable time to help you solve your problem. That's why feel free to CLICK their STARicon to say thank you -even the given idea/solution didn't really solve your queries. The time given to you deserves a small gratitude anyway.
Dare to give a pencil to a child. http://www.blackpencilproject.org/
omg you saved me!!! thanks soo very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks