| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FInd common data in one column then add number in adjacent column | Excel Worksheet Functions | |||
| compare data in column A with column B to find duplicates | Excel Discussion (Misc queries) | |||
| Find Last data in a column | Excel Worksheet Functions | |||
| find rows for unique data in 1 column and different data in other. | Excel Discussion (Misc queries) | |||
| Find data in Column D, add L in Column A | Excel Programming | |||
Linear Mode
