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

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

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