Thread: x and x+1
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default 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