Helper Table Written as a Range?

[MattDW]

Would anyone out there be able to help me to figure out how to take the helper table I created and express this, using a formula, in the format seen below?

Helper Table: http://staffweb.psdschools.org/mway/excelquestion3/

The data in columns L, M and N are the start of range values, end of range values and the single entity values, as seen in the expression below.

Desired Output:

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.Resour ceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.NetbiosName >= "PRE12344" and SMS_R_System.NetbiosName <= "PRE12349" or SMS_R_System.NetbiosName >= "PRE23465" and SMS_R_System.NetbiosName <= "PRE23466" or SMS_R_System.NetbiosName >= "PRE34563" and SMS_R_System.NetbiosName <= "PRE34567" or SMS_R_System.NetbiosName = "PRE65318" or SMS_R_System.NetbiosName = "PRE65319" or SMS_R_System.NetbiosName >= "PRE65321" and SMS_R_System.NetbiosName <= "PRE65322" or SMS_R_System.NetbiosName >= "PRE65324" and SMS_R_System.NetbiosName <= "PRE65326" or SMS_R_System.NetbiosName = "PRE16354" or SMS_R_System.NetbiosName = "PRE23468" or SMS_R_System.NetbiosName = "PRE23543" or SMS_R_System.NetbiosName = "PRE76236" or SMS_R_System.NetbiosName = "PRE94323"

Thanks much!

Matt