Forum Discussion
VLOOKUP with 2 conditions
How can I VLOOKUP into a seperate file using 2 conditions that must be met? i.e take the value that does not equal to zero for the lookup value
Thanks mathetes
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.
I modified the Summary File (to add in the column containing the second criterion) and then used the FILTER function instead of VLOOKUP. See if it delivers what you want.