Forum Discussion
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 compa...
You can use INDEX and MATCH for this as shown in the attached file.
Hi!
Can you just use a single IF formulation? Try this on I2 of your first sheet:
=HYPERLINK(IF(F2=Sheet2!E1,Sheet2!C1,""))
