Find the Row of a String from a Collection of Columns


The formula works on Microsoft Excel for Mac version 16.36.

Given:


Problem:
Kassandra is in which team?

Formula:
=INDEX(RESULT_ARRAY,MATCH(1,MMULT(--(COLUMN_HAYSTACK=NEEDLE),TRANSPOSE(COLUMN(COLUMN_HAYSTACK)^0)),0))

Actual Application:
=INDEX(A3:A6,MATCH(1,MMULT(--(B3:D6=A7), TRANSPOSE(COLUMN(B3:D6)^0)),0))

Result:
"Eagle"




Comments

Post a Comment

Popular posts from this blog

Terraform: Merge a List ofObjects into One

Image
The goal is to Merge a variable List of Objects from a Terraform Data Source   into One Object using Terraform's Merge function. mergedExpanded = merge(local.policy_parameters[*].parameters...) mergedHardcoded = merge(local.mergedExpanded[0].parameters,local.mergedExpanded[1].parameters,local.mergedExpanded[2].parameters)
Read more

SMS Notification using Gammu on Linux

Image
. So I got a call from the big boss, a client needs an SMS notification service. I said I will be needing a GSM Modem, a loaded SIM Card and a Linux Server. I was given the task and the equipment and now I will share how I set up the project up and working :).
Read more