Results 1 to 4 of 4

Multiple criteria lookup to return values in a column

Threaded View

  1. #1
    Registered User
    Join Date
    10-19-2010
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    2

    Multiple criteria lookup to return values in a column

    I have a table like this : (the excel file attached: YDJ.xlsx)

    Brand Size #ID Date Row Production No.
    GY 1100 ME4752 2-Oct 1 HB 072
    BS 900 E2E1051 2-Oct 1 HB 073
    HK 825 L1E1488 2-Oct 2 HB 074
    BS 750 A3E2081 2-Oct 2 HB 075
    BS 900 53E1978 2-Oct 1 HB 076
    GY 1000 E1E0519 2-Oct 2 HB 077
    BS 1000 M1E0193 2-Oct 2 HB 078
    GT 700 E1E0563 2-Oct 2 HB 079
    GY 1100 09T111049 3-Oct 2 HB 080
    GT 900 609S86-12 3-Oct 2 HB 081
    GT 1000 209S58-29 3-Oct 1 HB 082
    GT 900 609S89-28 3-Oct 2 HB 083
    GT 750 709S58-26 3-Oct 1 HB 084
    GT 900 209S58-26 3-Oct 1 HB 085
    BS 900 B2E2384 3-Oct 1 HB 086
    BS 1000 R3F0790 3-Oct 2 HB 087

    I need excel to show all the #ID (in a column on other sheet) that match the Date : 2-Oct and Row : 2 for example, so the result will be like this :
    #ID
    L1E1488
    A3E2081
    E1E0519
    M1E0193
    E1E0563
    #NUM!

    What formula to do that?

    Thank you very much guys! Any answer will be much appreciated.
    Last edited by ydj; 11-02-2010 at 11:37 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