Problems finding Cell Reference using Vlookup

[Robert.ulyatt]

Hi All,

I am currently having real problem using the formula below:

=INDEX(Data!C:C,MATCH(B7,Data!A:A))

What i am trying to do with this formula is return the cell address of an item that is in a different sheet.

The reference the for search is in Cell B7 which is a date, it then looks at a different sheet "Data" for this date which is in Column A. It then returns the Cell Reference of Column C of the same row.

Currently it is just returning the value of column C and not the cell reference.

Any Help greatly appreciated as i have scoured the Forum for answers.

Kind Regards
Rob Ulyatt

 

[circledchicken]

Hi Rob,

Not sure why you need the cell address, but perhaps try something like this instead:

="C" & MATCH(B7, Data!A:A)

 

[Robert.ulyatt]

Thank you for that circledchicken works perfectly.

I needed the cell address so that one of my VBA forms could reference it.

Thank You Once Again..!

Kind Regards
Rob Ulyatt

 

[circledchicken]

You're welcome, thanks for the feedback.