In sheet reed 96 in column k, i want numbers come from sheet manual 1 (according to column b15: C37.)
and in reed 96 sheet there is a dashboard in which m 124 will be according to column b (sheet reed 96) and n 124 will be according to column i(sheet reed 96) and q124 will be the total of column k of that design.
Please do it this is most important project
please help.
ok i have done dashboard requiremnt. now only need a formula which can import meters in column k in sheet reed 96, from manual 1 sheet (cell range b17:c27)
please do this only.
thanks in advance.
in sheet reed 96 in column k meters should be come according to column f, which should be match from manual 1 sheet
for example 90*100 metr is 2.45 (please see b17 & c17 in manual 1 sheet) it should be matched with f116 and value will be come in k116.
your post title says sum if formula. Your second and third posts seem to be refining your results but you haven't uploaded a new sheet which should account for any changes.
Are you looking for a vlookup formula that would return the value in column C of the manual 1 tab that "matches" the value in the reed 96 tab of column F? In other words simply a match between 90*100 and the 2.45 brought over from manual 1 to populate in K116?
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Hi to all. I have applied formula. Please check that.i want that when i fill m124 n124 o124. Then there should be come total required quantity of column i in p124 in reed 96.
And total of column k in the q 124 following the m124 n 124 o124.
While in column k meters should be come from sheet manual 1 cell range a15:f28
there are different & same values of 90*100-spl-2.45 and 90*100-bedsheet-3.1
in reed 96 column f and g should be look but value have to be pick up from manual 1 cell refernce a15:f28.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks