Forum Discussion

Vijay_Uppala's avatar
Vijay_Uppala
Copper Contributor
Dec 13, 2021
Solved

Lookup for a value in an array

Hello, I have a use case where I have to look up for a value that can be in an array and output a value from the corresponding output array. Here is my input table.  I have a Server Name column whi...
excel
Excel on Mac
Formulas and Functions
office 365
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Dec 14, 2021

    OliverScheurich 

    Probably.

    =INDEX($A$1:$A$40,AGGREGATE(15,6,ROW($B$1:$G$40)/($B$1:$G$40=I1),1))
Vijay_Uppala's avatar
Vijay_Uppala
Copper Contributor
Dec 14, 2021
PeterBartholomew1
Thank you for the response.
I couldnt get the 365 notation to work as well.
I'm assuming the virtualmachine is the named range for the names in columns J, VM is the is the array of all VMs (B1 to G40) and server is the array of A1 to A40. If so, i couldnt get this to work.
Let me know if i got this wrong.
  • Vijay_Uppala's avatar
    Vijay_Uppala
    Copper Contributor
    Dec 24, 2021
    thank you very much, Peter

Resources