=VLOOKUP(A1,B4:C60,2,0)

in A2



--
Regards,

Peo Sjoblom

(No private emails please)


"stephenlewin" wrote in message
...
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