Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Excel range lookup

Comment:

I have a set of numbers that I need to find out if they are in a certain range, if they are, I need them to report back the range For Ex: Column A (individual number) has 100, 101, 102... 999 Column B and C(contains the group range) (100-107,108-136,...888-945,946-999 I need to search column A against column B and C to see if the number from A falls into that range, if it does, I need it to list the individual numbers for A in column D next to the range it was found. I hope that makes sense and thanks in advance for any help you can provide. C

Access Locks

I need Help on Excel

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: I am looking to find out if a specific value falls in a range of values on a separate sheet and return a value. For example: Sheet 1 <TABLE> <TR><TH><TH>A<TH>B<TH>C <TR><TH>1&l...

Summary: In column A I have a list of items that all start with an A (a1 a2 a3 etc) In column B I want to use “lookup” to generate a sales report from another excel file, but if item a2 is not listed in th...

Summary: Several Things. The most obvious is the range. VBA does not recognise Excel ranges in their "spreadsheet" form. "sheet2!b:c" means "a bunch of alphanumeric characters" to the VBA compiler. ie. Specify...