Forum Discussion

Thames17's avatar
Thames17
Copper Contributor
Jan 29, 2020

Index and Match formula to be combined with if formula to return exact values.

Hi    I am trying to obtain following values and the data are picked up using Index & Match formula from another sheet matching rows and columns. I tried the "If formula" combined with "Index & Mat...
Formulas and Functions
Twifoo's avatar
Twifoo
Silver Contributor
Jan 30, 2020

Hi Thames17, 

Perhaps, this formula returns your desired result: 

=IFERROR(LOOKUP(INDEX('[Sheet1.xlsx]ITEM'!$B$5:$BO$1741,

MATCH($A4,'[Sheet1.xlsx]ITEM'!$A$5:$A$1741,0),

MATCH(AP$1,'[Sheet1.xlsx]ITEM'!$B$2:$BO$2,0)),

{"","FRE","G.S.T","N-T"},

{"","NONE","GST","NONE"}),

"ERROR")

Cheers,

Twifoo

Thames17's avatar
Thames17
Copper Contributor
Jan 30, 2020

HITwifoo 

 

It worked perfectly. Thank you very much. 

 

Cheers

Thames17. 

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Jan 30, 2020

    Thames17 , 

    You're very much welcome!

Resources