x and x+1
Change the 2 in the formula to 4
--
Regards,
Peo Sjoblom
(No private emails please)
"stephenlewin" wrote in message
...
excellent... it work, now there is another twist, what if i want to return
the value that is two columns away from the one the has the lookup data,
for
example if A1 matches B34, i want E34 returned, not C34, how do i do it?
"Ron Coderre" wrote:
If I understand you correctly, you want to see if the value in A1 matches
any
of the values in B4:B60. If YES, then return the corresponding value in
Col C
to A2.
Try this:
A2: =VLOOKUP(A1,B4:C60,2,0)
Does that work?
***********
Regards,
Ron
"stephenlewin" wrote:
i have two colums of data (B4:C60) that is related by row, i want to
analyse
the data so that if let's say A1 is equal to any of the B4:B60, then i
return the corresponding data from the D column in A2. for example, if
i
enter Blob in A1 and Blob is also in B26, then A2 will return C26. i
could
do it with the IF function but i can only use it inline 7 times and no
more.
if there a simple function like =IF(A1=B(x),C(x),(x=x+1)) that could
work?
(except that this one doesn't, it does not recognize what i mean by the
unknown (x)
looking forward to any help...
thanks
|