jeudi 10 décembre 2020

MY Vlookup is not returning the answer accordingly

i am struggling with my vlookup function. i have 2 sheets, and 1 is the data. By right when i select the cell A2 in sheet1, then should be return the correct value from data sheet. but now is when i select in cell A2 sheet1, it return wrong value.

(this formula is in Sheet1 B2): =Arrayformula(If(A2:A12="","",VLOOKUP(artist!A2:A10,artist!A2:C,MATCH(B1:C1,artist!A1:C1,0),0)))

Here is the sheet link: https://docs.google.com/spreadsheets/d/17yHf21Yodl7a7nfbe_K6H7Sem8F7ftIFVc1OJ3x9QCM/edit?usp=sharing

Please assist with thanks.

Aucun commentaire:

Enregistrer un commentaire