Search results

Thats sort of what I need although I have 3 instances, would I need to use a SUMPRODUCT?

Im wondering if there is anyway I can have more than one data validation list assigned to one cell based on whether an IF formula is true or false? eg. COL A, COL B, LIS, (Data Validation dropdown list) SDL, (Data Validation dropdown list) AQ, (Data Validation dropdown list) There will be...

Actually, dont worry Hui, Sajan's example worked thank you, now for my next post!

Hui, I am unable to view things in dropbox, could you please email me your example? I think you have my email address

Also, I should probably add that column B is the Data Validation, there should be a way of Marketing being able to choose the correct source as per the Entity, ideally (although I dont know how it can be done) if the Entity is LIS the Data Validation only lists the LIS Sources, and the same for...

I have a template that our Marketing Department records invoices on, in order to have them use the correct source codes I also had data validation rules mixed with VLOOKUP's pulling through the correct codes, unfortunately the problem occurs when the same source is used for different entities...

No I cannot, which is why I didnt, its just a normal COUNTIF I have other countifs working on the same worksheet, I am very capable of doing countifs I was just looking for possible reasons why it might return a wrong figure

I can't seem to work out whats going wrong with a simple COUNTIFS, I've even just broken it down to a COUNTIF and thats not even working, its returning a figure over 1000000 different to what it should be, the only thing that's a little bit different about it is that all critera are looking up...

Cool, it works, thank you! :-)

I've tried taking out the headers but it now brings back a zero result, there should be a different figure in here

Yes, there are definitely headers, this is bad I take it

No, its 2007. Im trying to create a template that will not be used by myself going forward, therefore the less there is to have to change the better, I dont really want to be replying on somebody remembering to increase the data range for different months, I'd like them just to be able to copy...

Yes, that's the plan unfortunately though that's still bringing through #VALUE!

I have used SUMPRODUCT before to bring back the sum of the specified critera but now I need the formula to bring back the sum by adding and subtracting different columns. The formula that I tried (that gets a #VALUE! error) is as follows...

Amazing Sajan, thank you soooo much for that! Thank you Luke as well for all your help it's really appreciated, and given me my first insight into VB!!! I cant thank you both enough!

IT WORKS!!!!

Sajan- Not sure what you mean by data types? The value that I'm looking up is actually SDLAG_AT1 and only appears in column AC in sheets BWApr, BWMay, BWJun I was thinking maybe only referencing this one column AC12:AC1385 rather than A12:AK13285 The other columns have all sorts of data in...

Now Im getting a #NAME? error

I followed your instructions, Im pretty sure it's a new module

Hi, I just changed them to be absolute and still no joy Im afraid, yes most of them should exist in the data but its just returning not found for all

Luke M, My VB formula is; Function BigLookup(xFind As Single, SearchRange As Range, xOutput As Range) 'set the default value BigLookup = "" 'IMPORTANT!!! 'Change the list of sheets as needed For Each sh In Worksheets(Array("BWApr", "BWMay", "BWJun"))...

Hi, I tried the above formula but it just returns "Not Found" for everything, my formula is as follows, have I done something wrong? I dont actually need a different field returned, so have kept the same XDH1...

Oh, I got a #VALUE! :-(

My Company blocks file sharing websites unfortunately, so Im unable to to upload it

I dont know the first thing about VBE, the only time I have ever had anything to do with Macros is when I clicked on "Record Macro" then edit, then I closed it again as it looked too complicated! I will give your instructions a go though and see how I get on (Fingers Crossed) Thanks