I have a single worksheet that has several rows and columns of data. I then have like 4 other sheets in the same file that are going to each have different information. What I want to do is to go through the entire first column looking for a particular word. I want it to take that word and the entire row associated with it containing various numbers and words and slap it on another worksheet so i can total it up and make a report based on this.
I have tried the vlookup but cannot figure out how to make it output the entire row instead of just one cell at a time. Is there a way to do this?
Perhaps excel is not the option I am looking for given what I want to do?
The information is primarily financial related, as in, I will be adding prices up for a total for products from each manufacturer (column A).
Thanks
I have tried the vlookup but cannot figure out how to make it output the entire row instead of just one cell at a time. Is there a way to do this?
Perhaps excel is not the option I am looking for given what I want to do?
The information is primarily financial related, as in, I will be adding prices up for a total for products from each manufacturer (column A).
Thanks
Facebook
Twitter