hi everybody
I have two vlookups for calculating charges, I am looking Vlookup or any other formula where, calculation will be done as per narration mentioned in "B" Column "Nature Bill" at present, manually i am changing formula
hi everybody
I have two vlookups for calculating charges, I am looking Vlookup or any other formula where, calculation will be done as per narration mentioned in "B" Column "Nature Bill" at present, manually i am changing formula
Last edited by jimmiboy; 07-11-2016 at 04:41 AM. Reason: solved
Try
I2=IF(E2=F2,(VLOOKUP(F2,Sheet2!B:E,4,0)*H2),(VLOOKUP(F2,Sheet2!B:E,4,0)*H2-(VLOOKUP(E2,Sheet2!B:E,4,0)*H2))) and drag down!
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks