Ubuntu
openoffice.org package

how can i match the one data to the other

Asked by Talha

i need an orientation of match formula

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Solved by:
GercoKees
Solved:
Last query:
Last reply:
Revision history for this message
Tony Pursell (ajpursell) said : 		#1

We need more description of your problem....please

Revision history for this message
Talha (tsajjad) said : 		#2

first of all i would like to appretiate your quick response.
the detail is given below;

Suppose i have 100 name in 1st spread sheet.
lets suppose the names are ; a,b,c,d,e,f,g,h,i,j,k,l,m,n,o....etc.

in 2nd spread sheet, i have 20 name which are from 1st spread sheet.
lets suppose the names are; d,g,i,o........etc.

so how can i match the sheet 1 and sheet 2, so i get the same 20 Names seprate(same in 1st sheet and 2nd sheet)
 (Like; d,g,i,o. are same in both sheets).
and different name septate.

hope to hear you soon.

Revision history for this message
Best GercoKees (gercokees) said : 		#3

Hi,
Lets try to get you in the right direction:
Try match and offset.
Match(search-string ; search-array ; parameter)
the parameter 0 searches for an exact match.
The result will be the number of the row where the search-string is found..

for example:
         columns
row A B C
1 a b =match(B1;A1:A8;0)
2 b e =match(B2;A1:A8;0)
3 c h =match(B3;A1:A8;0)
4 d
5 e
6 f
7 g
8 h

With offset you get the value of a cell, relative from an other cell
offset(reference ; rows ; columns ; with ; height )
for example:
=offset( a1 ; 2 ; 0 ; 1 ; 1)
will give the value of cell a3 (from a1 two cells down, zero cells to the right....)

Let us know when you still have more questions..

Revision history for this message
Talha (tsajjad) said : 		#4

thanks for your cooperation,

this problem also easily resolved by the following formula;
match($A$1:$A$8;$B$1:$B$8,0).

Regards.