Hi there,

I have a quick question, probably something really simple.

I've got a spreadsheet with lots of data in it and on another Tab I'm trying to do a summary of the data in various ways.

I am doing a simple VLookup for the basic tables, but is there a way of doing a VLookup based on 2 criteria?

I.e, I can do a lookup if, lets say, column G contains the word "Material". i can then set the column of the data I want it to return.

But, how can I set 2 criteria? I.e Column G contains the word "Material" AND Column H contains the word "Operations", for it to then return only the values in Column V that meet this criteria?

Do I have to nest the Vlookup in an IF statement? Or is there a much easier way?

Thanks in advance for any help!!!

Much appreciated.

Arun