Lookup Result - Cell Address, not the contents

[Scorpio]

Hi

I am drafting a large excel asset register spreadsheet.

I am having issues with a vlookup. What i am wanting is for the Vlookup formula to give me the cell address, rather than its result.

I have attached a example of what i am looking for.

Any help will be appreciated.

[mrice]

Maybe something like

= "F" & MATCH(C9,C3:C6,0) + CELL("row",C3:C6)-1

[Scorpio]

Hi mrice.

Thanks you, It's close but the result would need to be totally dynamic. I will be using this register for multiple clients and sometimes the "F" column will not always be relevant. I am also not going to be only one using it, so it kind of needs to be idiot proof as well (or as close as).

[mrice]

Could try a user defined function

Function VLOOKUPSpecial(LookupValue As Range, LookupRange As Range, IndexNumber As Integer) As String
For N = LookupRange.Row To LookupRange.Row + LookupRange.Rows.Count - 1
    If Cells(N, LookupRange.Column) = LookupValue Then
        VLOOKUPSpecial = Cells(N, LookupRange.Column).Offset(0, IndexNumber - 1).Address
        Exit Function
    End If
Next N
End Function

Type =VLOOKUPSpecial(A1,A1:D7,3) for instance.