Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Jul 2006
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Help with using lookup command (2003)

    I am trying to do a lookup formula to do the following , but need some assistance with how l go about doing it, what l require is as follows;

    1. find value in 2nd row as first row header

    2. find value in spreadsheet

    3. go along to change type column, if Logical then put “MACD SOFT” in Comments field , if Physical then put “MACD SOFT

    4.. If found in IDND spreadsheet put IDND value in “Team” column.

    5. Do same process for IISS spreadsheet in case value not in original spreadsheet.

    See screenshot for assistance.
    Attached Images Attached Images

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Help with using lookup command (2003)

    I am confused. can you elaborate?

    Perhaps provide a worksheet and list what the values in the example should be.

    Steve

Posting Permissions

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