Results 1 to 9 of 9

2 dimensional lookup

Threaded View

vamshi57 2 dimensional lookup 01-09-2011, 05:58 AM
DonkeyOte Re: 2 dimensional lookup 01-09-2011, 06:03 AM
vamshi57 Re: 2 dimensional lookup 01-09-2011, 06:20 AM
DonkeyOte Re: 2 dimensional lookup 01-09-2011, 06:30 AM
vamshi57 Re: 2 dimensional lookup 01-09-2011, 06:43 AM
vamshi57 Re: 2 dimensional lookup 01-09-2011, 06:54 AM
DonkeyOte Re: 2 dimensional lookup 01-09-2011, 06:57 AM
vamshi57 Re: 2 dimensional lookup 01-09-2011, 07:05 AM
DonkeyOte Re: 2 dimensional lookup 01-09-2011, 07:11 AM
  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