Hi All,
New to the forums and not all that great with Excel...I'm uploading a sample project that I will reference here...
What I need to do is have a specific string tested for and find ALL instances of it. After I have found all instances I need to take a value in the same row from each instance and add them all together...
Does anyone know if I can do this with vlookup or is it going to become a more intense problem to fix?
In my example sheet I have a sheet named STEEL that is the formulating sheet. Currently I am testing it on just the 10x20 B sheet but would like to combine it to include 10x20 A&C as well as Gangway, etc... You will see a couple of lines started but I can't figure how to get it to return multiple values or even if that is possible
Any help is greatly appreciated!
Thanks,
Justin
Bookmarks