In my excel , i have 5 columns as in attached excel
I would like to update Col E in Sheet "Calculation" based on date in work sheet "Band Details". Formula to be used is
Match band in col D of Sheet "Calculation" with band in "Band details" sheet
multiple FTE Size in "Calculation" sheet by the corresponding Weightage and fill col E in Sheet "Calculation"
Please Login or Register to view this content.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
I do not know how to apply this formula in excel..what i need is a simple vlook up or some thing similar
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks