chloenatassia
May 07, 2024Copper Contributor
Help with V Look Up
Hi,
I'm an average skilled Excel user and I've used v-lookups before but just can't seem to get this one right, if anyone can help please that would be amazing.
In Worksheet 1, I have a company name (F2). If this company name matches the same company name in Worksheet 2 (E1), I want to populate cell I2 in Worksheet 1 with a website from the same row as the company name in Worksheet2 (which is in C1). Would anyone know the formula I need to use?
Thank you
You can use INDEX and MATCH for this as shown in the attached file.