Help with V Look Up

[chloenatassia]

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

[#2]

@chloenatassia 

Hi!

Can you just use a single IF formulation? Try this on I2 of your first sheet:

=HYPERLINK(IF(F2=Sheet2!E1,Sheet2!C1,""))

[#3 · Accepted solution]

@chloenatassia 

You can use INDEX and MATCH for this as shown in the attached file.

[#4]

This is exactly what I needed. Problem solved. thank you so much! @OliverScheurich