When using VLOOKUP, is it possible use the reference value (parameter one) from one sheet, and then use an array to look in in a diffrent sheet? Or is this function only applicable to one sheet? I can't get it to work in multiple sheets, but was just curious. Is this an advantage of using INDEX(MATCH(), MATCH()) [which I'm using]?
Thanks for any input!