Forum Discussion
Find according to Reference
Hi everyone. I need some help with excel. I have 2 excel sheets, "Worksheet" and "EV List". In EV List, I need the data for the references mentioned there. And the data is in "Worksheet". The Refere...
In B2 on EV List:
=XLOOKUP(TEXTAFTER(B2, "-"), Worksheet!$B$2:$B$1000, Worksheet!$D$2:$G$1000, "", 2)
In Dutch:
=X.ZOEKEN(TEKST.NA(B2; "-"); Worksheet!$B$2:$B$1000; Worksheet!$D$2:$G$1000; ""; 2)
HansVogelaar& JKPieterse thank you!
I also managed to use VLOOKUP to return the values in "Worksheet" to the relevant reference in "EV List".