Help required on a Vertical and Horizontal lookup matching criterias

**stephboucher67** · 09-29-2022, 06:36 AM

Hi All

Please can you help with an issue i have with using Vertical and Horizontal lookups.....

Please see attached work sheet for details.

Using the Item, Quantity and Current Cycle i need to find a matching Planned Cycle - this must match the item, the Planned Cycle must be >= Current Cycle and the Cycle Quantity must be >= to the Quantity - the returning planned cycle must be the 1st cycle matching the criteria.

I have written a crude formula but this doesn't lookup on the item.

Hope this is clear enough and thank you in advance.

Steph

**davsth** · 09-29-2022, 07:06 AM

perhaps
=IF(RIGHT(INDEX(B10:G10,XMATCH(B4,INDEX(B11:G12,MATCH(B3,A11:A12,0),0),1)),3)*1<RIGHT(B5,3)*1,B5,INDEX(B10:G10,XMATCH(B4,INDEX(B11:G12,MATCH(B3,A11:A12,0),0),1))) as long as the last 3 digits of the cycle number are a number

or
=INDEX(B27:G27,MAX(XMATCH(B21,INDEX(B28:G29,MATCH(B20,A28:A29,0),0),1),MATCH(B22,B27:G27,0)))

**stephboucher67** · 09-29-2022, 07:11 AM

Thank you, that appears to be working great!!!

Help required on a Vertical and Horizontal lookup matching criterias

LinkBack

Thread Tools

Rate This Thread

Display

Help required on a Vertical and Horizontal lookup matching criterias

Re: Help required on a Vertical and Horizontal lookup matching criterias

Re: Help required on a Vertical and Horizontal lookup matching criterias

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA Code Required to convert Horizontal to Vertical

Horizontal Lookup for date, vertical lookup for value then output list of names that match

Finding a specific value based on vertical & horizontal criterias

[SOLVED] Sumif 2 criterias one horizontal with duplicates and 1 vertical

Horizontal and Vertical matching together

[SOLVED] 3 criteria for horizontal and vertical matching

3 criteria for horizontal and vertical matching from a table

Bookmarks

Bookmarks

Posting Permissions