Lookup & Match
 

I was trying to match up 2 set of data

one set have Point Nos(a1) & Proposed Elevations(b1)
other set have Point Nos (h1) & Measured Elevations(J1)
a1 & h1 are same Point Nos but not all of them.
I try to write a formula {if (a1=h1), put j1 to c1}
thats is the basic idea than i can check the relationship between proposed
and measured.

other thing is that sorting command is not working properly
its goes like 10,1011,1012......9,90,980 sort of like that,It didnt work
like 9,10,90,980,1011,1012


any ideas will be welcomed.

Lookup & Match
 

In cell C1:
=IF(A1=B1,J1,"")

As for sorting: what you are seeing is an alphabetic sort on the numbers, so
"10" comes before "2" (because "1"__ comes before "2"__)
Change them to numeric format to sort numerically.
--
- K Dales


"amharan" wrote:

I was trying to match up 2 set of data

one set have Point Nos(a1) & Proposed Elevations(b1)
other set have Point Nos (h1) & Measured Elevations(J1)
a1 & h1 are same Point Nos but not all of them.
I try to write a formula {if (a1=h1), put j1 to c1}
thats is the basic idea than i can check the relationship between proposed
and measured.

other thing is that sorting command is not working properly
its goes like 10,1011,1012......9,90,980 sort of like that,It didnt work
like 9,10,90,980,1011,1012


any ideas will be welcomed.

Lookup & Match
 

let me clarify something I have almost 1500 nos to match and I already have
about 900 points, so its not always A1=B1, beacuse A1 could be anywhere in
the B column, in that I case I cant put a1 =b1, I want to lookup that column
and match it so it will select the appropriate data.

Thanks

"K Dales" wrote:

In cell C1:
=IF(A1=B1,J1,"")

As for sorting: what you are seeing is an alphabetic sort on the numbers, so
"10" comes before "2" (because "1"__ comes before "2"__)
Change them to numeric format to sort numerically.
--
- K Dales


"amharan" wrote:

I was trying to match up 2 set of data

one set have Point Nos(a1) & Proposed Elevations(b1)
other set have Point Nos (h1) & Measured Elevations(J1)
a1 & h1 are same Point Nos but not all of them.
I try to write a formula {if (a1=h1), put j1 to c1}
thats is the basic idea than i can check the relationship between proposed
and measured.

other thing is that sorting command is not working properly
its goes like 10,1011,1012......9,90,980 sort of like that,It didnt work
like 9,10,90,980,1011,1012


any ideas will be welcomed.