find data in one column and use data in the next column over Exce
 

I want to find a number in column b from 2 to 10000 and if a number comes up
with the one i want i want it to pick the next column d information in that
cell

example
i want to find 1447
and i find it at cell b28 then i want to use cell d28 info to use the data
right
not cell b28 or d1

find data in one column and use data in the next column over Exce
 

You want to use a Vlookup function something like this...

=vlookup(A1, $B$2:$D$10000, 3, false)

Where cell A1 contains 1447.

HTH

"charles" wrote:

I want to find a number in column b from 2 to 10000 and if a number comes up
with the one i want i want it to pick the next column d information in that
cell

example
i want to find 1447
and i find it at cell b28 then i want to use cell d28 info to use the data
right
not cell b28 or d1

find data in one column and use data in the next column over Exce
 

Charles,

Dim myNum As Long
Dim myCell As Range
myNum = 1447
Set myCell = Range("B:B").Find(myNum, , , xlWhole)(1, 3)
MsgBox myCell.Address & " is " myCell.Value

HTH,
Bernie
MS Excel MVP


"charles" wrote in message
...
I want to find a number in column b from 2 to 10000 and if a number comes
up
with the one i want i want it to pick the next column d information in
that
cell

example
i want to find 1447
and i find it at cell b28 then i want to use cell d28 info to use the data
right
not cell b28 or d1