Forum Discussion

Kieren20101's avatar
Kieren20101
Copper Contributor
Jan 15, 2024
Solved

lookup help

Hi All,   New to the lookup formula and I'm trying to copy data from sheet 2 to sheet 1.  I know how to use the lookup function but I'm struggling with the Table/lookup array & return array. For th...
excel
  • Rodrigo_'s avatar
    Rodrigo_
    Jan 17, 2024

    Kieren20101 

    I have attached a sample file based on the screenshots you provided.
    Borefield sheet:

    Asset Condition sheet:

    the formula used in Asset Condition sheet to lookup your asset/generator to Borefield sheet in column B and I.
    =IFERROR(IFERROR(INDEX(Borefield!$A$4:$A$30,MATCH($A2,Borefield!$B$4:$B$30,0)),INDEX(Borefield!$I$4:$I$30,MATCH($A2,Borefield!$J$4:$J$30,0))),"Not Found")

Kieren20101's avatar
Kieren20101
Copper Contributor
Jan 17, 2024

Rodrigo_ ,

 

Sorry not really sure how to do that?

Rodrigo_'s avatar
Rodrigo_
Iron Contributor
Jan 17, 2024

Kieren20101 

I have attached a sample file based on the screenshots you provided.
Borefield sheet:

Asset Condition sheet:

the formula used in Asset Condition sheet to lookup your asset/generator to Borefield sheet in column B and I.
=IFERROR(IFERROR(INDEX(Borefield!$A$4:$A$30,MATCH($A2,Borefield!$B$4:$B$30,0)),INDEX(Borefield!$I$4:$I$30,MATCH($A2,Borefield!$J$4:$J$30,0))),"Not Found")

  • Kieren20101's avatar
    Kieren20101
    Copper Contributor
    Jan 17, 2024

    Rodrigo_ ,

     

    You're a legend! Thanks so much for your help i would have never got that.

Resources