How to assign ID in this way?

[changeable]

Hi i have somedata that looks like this:

[image: http://img.photobucket.com/albums/v509/changeable/data.jpg]

How can i assign an ID for each row to a columns next to the Column
if the column E and column F had match certain defined criteria?
This is how the criteria looks like:

[image
http://img.photobucket.com/albums/v509/changeable/criteria.jpg]

For example: Row 3 matched the criteria of Row 10866 since E3 is bigge
than 3.121694 but smaller than 3.122874. Due to this reason, i need t
place and ID "26" at H3. Similary, if others row in my database(1s
picture) that matched some of the criteria , says, criteria 31(no
shown in pic 2 but it is designed in that format), a 31 should place i
the H columns of the corresponding rows.

How can i achieve this in excel? Thanks

+-------------------------------------------------------------------
|Filename: criteria.jpg
|Download: http://www.excelforum.com/attachment.php?postid=2755
+-------------------------------------------------------------------

 

[David McRitchie]

You can use VLOOKUP see
http://www.mvps.org/dmcritchie/excel/vlookup.htm

But you will have to separate your data as show in rows10939-10867
into two tables one for xLB and the other for yLB with the id number
to the right because that is where VLOOKUP has to go when you get
a match. Remove the "<=" part because you must have numbers only
in that column. Sort all data on the revised xLB column. Do the same
for the another table with the yLB if you will be doing something similar
for those numbers.

This is strictly table lookup material that can be done with VLOOKUP,
after you put your tables into order.

In the future PLEASE try to write a question that does not rely on pictures.
when you cross over to text only newsgroups, questions and
answers are expected to be in text and text is what people
search the archives on when they look for previously answered
questions. Printing out pictures, questions and trying to figure out
what the question is hardly lends itself to quick turnaround.
http://groups.google.com/advanced_group_search?q=group:*Excel*&num=100
For information on searching newsgroups
Excel Newsgroups & Searching Newsgroups
http://www.mvps.org/dmcritchie/excel/xlnews.htm

Also if you are going to use the newsgroups, real names are
a lot more friendly. xlforums is not the newsgroups all they do
is repost your question on a newsgroup where people who have
absolutely nothing to do with xlforums are answering your question.
The worst part with everything touching xlforums gets stored on a
web pages so that when one does a web search they pull in tons of
newsgroup posting (with advertising) instead of organized web
pages.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Hi i have somedata that looks like this:

[image: http://img.photobucket.com/albums/v509/changeable/data.jpg]

How can i assign an ID for each row to a columns next to the Column G
if the column E and column F had match certain defined criteria?
This is how the criteria looks like:

[image:
http://img.photobucket.com/albums/v509/changeable/criteria.jpg]

For example: Row 3 matched the criteria of Row 10866 since E3 is bigger
than 3.121694 but smaller than 3.122874. Due to this reason, i need to
place and ID "26" at H3. Similary, if others row in my database(1st
picture) that matched some of the criteria , says, criteria 31(not
shown in pic 2 but it is designed in that format), a 31 should place in
the H columns of the corresponding rows.

How can i achieve this in excel? Thanks.


+-------------------------------------------------------------------+
|Filename: criteria.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=2755 |
+-------------------------------------------------------------------+