Tricky. If, then, hyperlink

[toughiv]

Got to be honest, been around the houses. No luck. Its frying my brain, so decided to ask online - maybe you smart people can help

I am trying to setup a reminder system for myself.

Basically, I have a spreadsheet where the coloumns are: Name, Date , Invoice Received etc....

I am trying to make a conditon whereby If i enter the name "joe bloggs" into Coloumn A, then that cell will become a hyperlink to an outlook email that has been stored on my HDD.

For example:

=IF(A:A, "Joe Bloggs", HYPERLINK(C:\USERS\....etc), "Click Here", "")

So I am trying to say if the value of a cell in this column is "joe bloggs" - Become a hyperlink that says "click here" - which will then take me to the relevant email regarding "joe bloggs".
If it isnt "joe bloggs" then do nothing - show the intended cell value ... i.e. "James patterson"

Hope you can help!

Thanks

[ragulduy]

Pretty close, the click here bit needs to be a part of the hyperlink function and you need to change the first part of the if statement into an logical test.

i.e.
in B1 type:
=IF(A1="Joe Bloggs",HYPERLINK("C:\Users\...etc","Click Here"),"")
which will turn B1 into a hyperlink if you type Joe Bloggs in A1.
However, it seems as though you want the actual cell in column A to become the hyperlink, which you cannot do without using VBA.

[toughiv]

Pretty close, the click here bit needs to be a part of the hyperlink function and you need to change the first part of the if statement into an logical test.

i.e.
in B1 type:
=IF(A1="Joe Bloggs",HYPERLINK("C:\Users\...etc","Click Here"),"")
which will turn B1 into a hyperlink if you type Joe Bloggs in A1.
However, it seems as though you want the actual cell in column A to become the hyperlink, which you cannot do without using VBA.

Would it be possible instead, to make it so that B1 displays "Click Here" if A1says "joe bloggs"...B2 display "click here" if A2 displayed "joe bloggs" etc.

Better yet - since I'll have multiple names over the course of this project, would VBA be the realistic way to go?

Or is it possible to have multiple conditional functions acting at the same time across a number of cells.

I.e. If i have to keep an eye out for 3 names ... let'say "Joe Bloggs, John Smith and Bob's Uncle"

Can I have it so that the cells next to each name respectively simply states "see query email folder".

Again, I would need this to be in effect on a whole column.

hope that makes sense.

[ragulduy]

You can copy the formula down to make it work down the column. If you have multiple names it gets a bit messy trying to put it all in one folder but you can use a look-up table rather than VBA.

I've attached an example.

[toughiv]

Wow - Worked like a charm!

Thank you very much Ragulduy!