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

Send SMS using Windows and any GSM Modem

Image
Since We have posted how to send SMS using Linux Command line, It will be unfair if we don't do it on Windows OS. So basically We only need a GSM Modem, GAMMU for Windows, and of course Windows 7. My PC has a 64bit architecture, so We will be using the 64bit GAMMU for this tutorial.  
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