Multiple Creteria Lookup(Between Dates)
On Jun 25, 9:04*am, joeu2004 wrote:
Alternatively, put =MATCH(A2:Sheet1!$A:$A) into a helper cell
Typo. That should be:
=MATCH(A2,Sheet1!$A:$A)
I wrote:
Those formulas assume that every machineID in column
Sheet2!A:A appears in Sheet1!A:A; that is, no errors.
They also assume that Sheet1 data is sorted with column A in ascending
order.
If that is not the case, you will need 0 in the 4th VLOOKUP parameter
and the 3rd MATCH parameter. However, it would be more efficient to
ensure that Sheet1 data is sorted.
|