04-01-2020 04:25 AM
04-01-2020 05:34 AM - edited 04-01-2020 05:35 AM
I'm sure that what you're wanting to do is clear in your own mind; your description of it, however, is not clear enough for somebody else to reliably answer. Could you spell out a little more clearly--using an example--what two conditions might be, why might one not be met, what the nature of the table in which we're doing the VLOOKUPing is, whether or not you're expecting (requiring) an exact match of each of two criteria...
You see what I mean: there are a lot of questions that need to be answered before we can make an educated guess on how to make such a formula work.
In fact, if you have the actual spreadsheets and can upload them (or a representative sample of them), that would be ideal.
04-01-2020 06:20 AM
I am pulling data from quite a large file into a seperate summary spreadsheet that deals with different product numbers, the first column contains the product numbers as shown in the simplified example..
As you can see in the data pull file, 2 product numbers appear twice. I want to pull the DAV column figures into the Summary File based on the product number and centre. To fix this, I wanted to add in a second criteria to meet but have been unsuccessful.
Thanks for your help.