Johnny Thunder
Well-known Member
- Joined
- Apr 9, 2010
- Messages
- 693
- Office Version
- 2016
- Platform
- MacOS
Hello all,
I need help with a lookup and not sure how to achieve this.
My dilemma:
I need a 2 way look done on a row by row basis, similarly how a Vlookup would work except a Vlookup is done on a one criteria method.
Sheet1 = PO Details
Sheet2 = PO database
Row to Enter Formula: Sheet1.Cell (H2)
Criteria To Match 1: Cell Sheet1 (C2) = Vendor Name
Criteria To Match 2: Cell Sheet1 (E2) = Title
Lookup Criteria 1: Sheet2 (C2) = Vendor Name
Lookup Criteria 2: Need to search E2:P2 for Value if it matches Criteria from Criteria 2 (Title)
Return Value: Sheet2 (B2) = Title Category
The main issue that I am having is that sometimes my PO database has 1 line for vendor but that line touches 5 Titles and the titles are displayed in the same row Sheet2.Columns(E:P) but my PO Details may only need to have data from 1 of the titles.
Sheet1 Sample
<tbody>
</tbody>
Sheet2 Sample
<tbody>
</tbody>
Any help is appreciated. Never done anything like this so I am kinda lost.
I need help with a lookup and not sure how to achieve this.
My dilemma:
I need a 2 way look done on a row by row basis, similarly how a Vlookup would work except a Vlookup is done on a one criteria method.
Sheet1 = PO Details
Sheet2 = PO database
Row to Enter Formula: Sheet1.Cell (H2)
Criteria To Match 1: Cell Sheet1 (C2) = Vendor Name
Criteria To Match 2: Cell Sheet1 (E2) = Title
Lookup Criteria 1: Sheet2 (C2) = Vendor Name
Lookup Criteria 2: Need to search E2:P2 for Value if it matches Criteria from Criteria 2 (Title)
Return Value: Sheet2 (B2) = Title Category
The main issue that I am having is that sometimes my PO database has 1 line for vendor but that line touches 5 Titles and the titles are displayed in the same row Sheet2.Columns(E:P) but my PO Details may only need to have data from 1 of the titles.
Sheet1 Sample
Vendor Name | Title | Formula column |
Vendor1 | Title1 | *need a formula Here |
Vendor2 | Title2 | *need a formula Here |
<tbody>
</tbody>
Sheet2 Sample
Title Category | Vendor Name | Possible Title1 | Possible Title 2 | Possible Title 3 |
Category1 | Vendor1 | Title1 | ||
Category2 | Vendor2 | Title2 | Title4 | Title5 |
<tbody>
</tbody>
Any help is appreciated. Never done anything like this so I am kinda lost.