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
|