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 Reference in “EV List” might not always match 100% to the “Naam” column in “Worksheet”, but the number part in the reference should match.
So I need a formula which can look for the number part of the reference in “EV List” and see if it matches in “Worksheet”. If the number in “Worksheet” matches with a number in “EV List”, I want it marked in for example column I in “Worksheet” that it matches to a number in “EV List”.
Thank you!
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 Reference in “EV List” might not always match 100% to the “Naam” column in “Worksheet”, but the number part in the reference should match.So I need a formula which can look for the number part of the reference in “EV List” and see if it matches in “Worksheet”. If the number in “Worksheet” matches with a number in “EV List”, I want it marked in for example column I in “Worksheet” that it matches to a number in “EV List”. Thank you! Read More
