LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lookup Formula: Return 1st match, then 2nd match, then 3rd match Scott Excel Discussion (Misc queries) 4 December 11th 09 05:50 AM
using MATCH, and LOOKUP harvey1649 Excel Worksheet Functions 9 May 7th 07 07:05 AM
Lookup? Match? pulling rows from one spreadsheet to match a text f cjax Excel Worksheet Functions 3 July 21st 06 02:51 PM
Lookup Match LookupTroubles Excel Worksheet Functions 1 June 22nd 05 05:12 PM
MATCH, LOOKUP, or ??? Ed[_9_] Excel Programming 2 July 10th 03 04:41 PM


All times are GMT +1. The time now is 11:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"