Hi.
I have a spread sheet which I use at work. It contains up to 1300 lines of information, not always listed in alphabetical order.
I am looking for a formula which will search the spread sheet for a specific piece of information using multiple criteria such as:
Branch name Customer Type Month and then the actual figure
and then return the number to another TAB on the same spread sheet. The main data sheet will not always be the same size so I cant simply copy the cell to my summary page. I need the formula to search using multiple criteria. I have tried V and H lookup with no joy and I am now being drive mad by this, please help if you can.
Kind Regards
Paul
Ps Tried uploading an example file but for some reason I cant add it?
Bookmarks