I have a workbook where I am matching on multiple values -- Using a Index match match function. Can you use match to match on two blank cells (or cells with no values?)?? Let's say I have this on worksheet 1 and want to match on horsehead & color to worksheet 2 in order to pull in the quantity. Well it works great when the color is specified, but any time I try to use this formula and the color is blank/null/omitted I gget a #N/A Returned? Can Index/match match on a null value?
Some sample data:
Item ------ Color ------- Quantity
HorseHead ---- Red ----
HorseHead ----- ----
Bookmarks