Results 1 to 3 of 3

To refer certain value from other sheet

Threaded View

  1. #1
    Registered User
    Join Date
    10-07-2010
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    4

    Question To refer certain value from other sheet

    Sheet 1:
    A1 = 80; B1 = 30;
    A2 = 81; B2 = 33;
    A3 = 82; B3 = 37;

    Sheet 2:
    a) When user key in 80, 30 should display. How do I display the next column value 30 in this case?

    b) What function to use to scan all A column till it hits 80?

    Thank you,
    Last edited by pastecopy; 03-19-2011 at 09:48 PM.

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