I get result like this (if match the 2 loockup vaues (100 is column b wise & general is row 8 wise match loockup values)

Results are show like General and Name in second screenshot

Google Sheet Link:

Get result screenshot:

Problem is mentioned in screenshot and get the result like this Screenshot

CodePudding user response：

Use filter(), like this:

=filter(
  CLIENT!C1:J1, 
  C2 = filter(CLIENT!C8:J, B2 = CLIENT!B8:B) 
)

CodePudding user response：

Please Add with Serial Number in Before result column automatically Starting with 1,2,3....

And Also add count of number of list.

Like this Screenshot enter image description here