Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lookup Formula: Return 1st match, then 2nd match, then 3rd match | Excel Discussion (Misc queries) | |||
using MATCH, and LOOKUP | Excel Worksheet Functions | |||
Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
Lookup Match | Excel Worksheet Functions | |||
MATCH, LOOKUP, or ??? | Excel Programming |