Required help in Hyperlink

[Vikram_Athwani]

Dear All,

I'm looking help in hyperlink.

my case is like, i got one excel file and in sheet1 Cell B2 have values with Hyperlink, same i want to copy in  Sheet2. with one more condition like any values changes to Cell B2 from sheet1 the same values should popup in Sheet2 where the cell is linked.

Sample file attached

[#2]

@Vikram_AthwaniThe VLOOKUP function can handle this for you. Please see in attached file.

It looks for the name in the table of sheet 1 and returns the current value.

Alan

[#3]

@Alan Murray 

Thanks for your help, but it doesnt suffice my request :(

[#4]

@Vikram_Athwani

Please see attached file. This one includes the hyperlink that you requested.

I have used the HYPERLINK function around your existing link. The cell reference you used could be replaced by any formula if you did need a VLOOKUP or something else there.