Thread: Lookup & Match
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
amharan amharan is offline
external usenet poster
 
Posts: 6
Default 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.