Results 1 to 9 of 9

2 dimensional lookup

Threaded View

  1. #1
    Registered User
    Join Date
    11-07-2009
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    81

    2 dimensional lookup

    In the spreadsheet attached I have two worksheets A and B . A has the raw data

    (a) - Based on the raw data . Values should be in returned in C3 of B worksheet using the lookup formulas . It should look for C2 from Column A of A worksheet & Match it with B3 from Row A of A worksheet .

    Incase if there are no values , it should return zeros .

    (b) In worksheet B , Cell C2 has the data validation list , each time I update the sheet A I need to manually change the range . Can I get a formula , so that the range is automatically adjusted based on the data in worksheet A .

    Thank you
    Attached Files Attached Files

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