B
Blaknight
Hello All,
My first post here as i am very stuck with a very complex formula.
-=See attachment=-
Please if you can help grab the attachment so you know what i am o
about.
This is my problem. I have 6 columns of data labeled
- Item, Date, Qty, Quality, Action, Charater.
What i want is the formula to search A11 to F41 (F41 will be greate
with more data entered) for a word in column A say *Medium Leather
then look for the value in column C of that word found in column A an
continue.
I have achieved this but when it has found the 1st word it doesn'
continue on to find another word of the same. This is what i hav
used.
=VLOOKUP("Medium Leather",A11:F41,3,)
Then on top of that i want it to look in column E for one of two words
Deposit and Withdrawn. I want the formula to add the data found i
column C when the word Deposit has been found in column E, an
subtracted if the word Withdrawn has been found.
This infomation needs to be placed in the Qty column in the *Total
Table* next to the corresponding Item.
So. basically i want
- Search Entire *Data Table* A - F, 11 - ** for Item
- Get value in C
- Work out if C value is - or + from E (Deposit = +, Withdrawn = -)
- Get current total value sum in I
I think you could only iunderstand if you download the attachment.
Thanks in advanced.
Blaknigh
+-------------------------------------------------------------------
|Filename: help_sKsLeather Blotter.zip
|Download: http://www.excelforum.com/attachment.php?postid=3836
+-------------------------------------------------------------------
My first post here as i am very stuck with a very complex formula.
-=See attachment=-
Please if you can help grab the attachment so you know what i am o
about.
This is my problem. I have 6 columns of data labeled
- Item, Date, Qty, Quality, Action, Charater.
What i want is the formula to search A11 to F41 (F41 will be greate
with more data entered) for a word in column A say *Medium Leather
then look for the value in column C of that word found in column A an
continue.
I have achieved this but when it has found the 1st word it doesn'
continue on to find another word of the same. This is what i hav
used.
=VLOOKUP("Medium Leather",A11:F41,3,)
Then on top of that i want it to look in column E for one of two words
Deposit and Withdrawn. I want the formula to add the data found i
column C when the word Deposit has been found in column E, an
subtracted if the word Withdrawn has been found.
This infomation needs to be placed in the Qty column in the *Total
Table* next to the corresponding Item.
So. basically i want
- Search Entire *Data Table* A - F, 11 - ** for Item
- Get value in C
- Work out if C value is - or + from E (Deposit = +, Withdrawn = -)
- Get current total value sum in I
I think you could only iunderstand if you download the attachment.
Thanks in advanced.
Blaknigh
+-------------------------------------------------------------------
|Filename: help_sKsLeather Blotter.zip
|Download: http://www.excelforum.com/attachment.php?postid=3836
+-------------------------------------------------------------------