Results 1 to 4 of 4

VLOOKUP with multiple identical keys !!!

Threaded View

jyadul VLOOKUP with multiple... 10-10-2006, 12:33 AM
jyadul VLOOKUP with multiple... 10-10-2006, 12:35 AM
Bryan Hessey If the value for line 2 is... 10-10-2006, 05:17 AM
jyadul hey, Bryan! thanks for... 10-11-2006, 12:20 AM
  1. #1
    Registered User
    Join Date
    10-10-2006
    Posts
    3

    VLOOKUP with multiple identical keys !!!

    hi, all!

    can any of you tell me how do i solve this problem i am facing?

    I want the correct value in the second table as indicated.

    e.g., the "Value" in the first row in the second table should be 3424 (by observation) as "Location" 0.261 is within the range of 0.189 to 0.830 for Item 200000002 in the first table (second row). Now the problem is i have thousands of data. so how do i make excel do it for me, i.e., return me the right value at a location of an item as specified by the range? By using VBA/Macro. I am new to these VBA stuffs!

    Any help will be appreciated.

    Thanks.
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1