Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to get search and transfer
I have a sheet, where i collect information from sheet2, sheet3.......
In sheet1, there is a cell cald "CAR". In sheet2, all CAR's are lined up, with ColummA: Fabric ColummB: Model ColummC: Variant ColummD: "a 10 digit nr." In sheet1, i would like to search after a specifik car, e.g. Opel - Vectra - 2,0 and then get the 10 digit nr return. Anyone that could help me ? -- kinoha - using excel2002 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to get search and transfer
Perhaps a look in the help index for VLOOKUP would be helpful?
-- Don Guillett SalesAid Software "kinoha" wrote in message ... I have a sheet, where i collect information from sheet2, sheet3....... In sheet1, there is a cell cald "CAR". In sheet2, all CAR's are lined up, with ColummA: Fabric ColummB: Model ColummC: Variant ColummD: "a 10 digit nr." In sheet1, i would like to search after a specifik car, e.g. Opel - Vectra - 2,0 and then get the 10 digit nr return. Anyone that could help me ? -- kinoha - using excel2002 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to get search and transfer
Hi
With Opel in A1 of Sheet1, Vectra in B1 and 2,0 in C1 Try the array entered formula {=INDEX(Sheet2!$D$1:$D$10, MATCH(1,(Sheet2!$A$1:$A$10=$A1)* (Sheet2!$B$1:$B$10=$B1)* (Sheet2!$C$1:$C$10=$C1),0))} To commit or Edit the formula use Control + Shift + Enter (CSE). When you use CSE, Excel will insert the curly braces { } for you. Do not type them yourself. Change ranges to suit, but ensure that they are equal length. -- Regards Roger Govier "kinoha" wrote in message ... I have a sheet, where i collect information from sheet2, sheet3....... In sheet1, there is a cell cald "CAR". In sheet2, all CAR's are lined up, with ColummA: Fabric ColummB: Model ColummC: Variant ColummD: "a 10 digit nr." In sheet1, i would like to search after a specifik car, e.g. Opel - Vectra - 2,0 and then get the 10 digit nr return. Anyone that could help me ? -- kinoha - using excel2002 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Transfer data from Text Form Fields in MS Word into Excel? | Excel Discussion (Misc queries) | |||
Transfer Email addresses from spreadsheet to email address book | Excel Discussion (Misc queries) | |||
How do I transfer excel smarticons from my old pc | Setting up and Configuration of Excel | |||
Look up and Transfer Data | Excel Discussion (Misc queries) | |||
lookup and transfer data | Excel Discussion (Misc queries) |