formula to find a specific value and return it in another ce
Upcoming Power Excel Seminars
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: formula to find a specific value and return it in another ce

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    i am using excel.in colum D there is values
    from 1-1000(d2-d1001),in row A there is names
    of people.(A3-A30).how do i return a value in for example mr.smith(column)and 500.ie.go down to 500 and go across to mr.smith(colum G) and find value.i hope this makes sense.

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,768
    Post Thanks / Like
    Mentioned
    11 Post(s)
    Tagged
    1 Thread(s)

    Default

      
    On 2002-03-17 13:04, explorious wrote:
    i am using excel.in colum D there is values
    from 1-1000(d2-d1001),in row A there is names
    of people.(A3-A30).how do i return a value in for example mr.smith(column)and 500.ie.go down to 500 and go across to mr.smith(colum G) and find value.i hope this makes sense.
    The layout is confusing:

    Where do you have the names exactly -- which row? In which cell do you first name and which cell do you have the last name?

    The numbers seem to be in D. And the first number in D2 and last number in D1001. Right?

    Aladin

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com