F Frank Kabel Feb 19, 2004 #2 Hi one way: - create a helper column in your lookup range - concatenate both columns (e.g. =B1 & C1) - copy this formula down use this helper column to compare your lookup value
Hi one way: - create a helper column in your lookup range - concatenate both columns (e.g. =B1 & C1) - copy this formula down use this helper column to compare your lookup value
D Dave Peterson Feb 20, 2004 #3 Another way: =INDEX($L1:$L999,MATCH(W1&CHAR(1)&X1,$A$1:$A$999&CHAR(1)&$B1:$B$999,0)) This matched W1&X1 with A1&B1 through A999&B999. and returned the value in column L.
Another way: =INDEX($L1:$L999,MATCH(W1&CHAR(1)&X1,$A$1:$A$999&CHAR(1)&$B1:$B$999,0)) This matched W1&X1 with A1&B1 through A999&B999. and returned the value in column L.
D Dave Peterson Feb 20, 2004 #4 and forgot to add... This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it correctly, excel will wrap curly brackets {} around your formula. (don't type them yourself.)
and forgot to add... This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it correctly, excel will wrap curly brackets {} around your formula. (don't type them yourself.)
