Thread: find data in one column and use data in the next column over Exce
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_3_] Jim Thomlinson[_3_] is offline
external usenet poster
  
Posts: 983
Default 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

Reply With QuoteReply With Quote