I have two worksheets that contain similar information. What I need is a
formula that will lookup the Value of column A in worksheet one, but also
theres a second condition that I want it to meet which is in column B. So
basically if these two conditions are met then I want to see the result from
using worksheet 2 as the lookup reference table. Does anyone know the correct
format for a two condition Vlookup? Any help is greatly appreciated.