B
=BA=Spike
Hi
Im trying to use the vlookup function.
The problem I have is, I need it to do the lookup over three rows.
(i.e. A1:C1) with the prospect of only having values in one row, or
having more than one row populated. It would then check a range, and
return a value.
i.e. =VLOOKUP(A1:C1,D1:M21,6,False)
But this does not work.
Is there a way of having it lookup a value between A1:C1 and then do
the rest of the process?
Thanks
Spike
Im trying to use the vlookup function.
The problem I have is, I need it to do the lookup over three rows.
(i.e. A1:C1) with the prospect of only having values in one row, or
having more than one row populated. It would then check a range, and
return a value.
i.e. =VLOOKUP(A1:C1,D1:M21,6,False)
But this does not work.
Is there a way of having it lookup a value between A1:C1 and then do
the rest of the process?
Thanks
Spike