SOLVED

Help with V Look Up

Copper Contributor

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

3 Replies

@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,""))

 

best response confirmed by Hans Vogelaar (MVP)
Solution

@chloenatassia 

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

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

1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

@chloenatassia 

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

View solution in original post