Hi All,
What i am wanting to do is Vlookup using the active row and column 5 so no matter where the formula is placed, it will still bring up the correct value of that row.
So for example when i type the vlookup into the vlookup column, i want it to give me the last name after looking up the first name. I want to be able to put the code into any of the vlookup cells without having to change the formula.(active row)
The example below is terrible but i hope it helps[TABLE="class: grid, width: 500"]
[tr][td][/td][td][/td][/tr]
[/TABLE]
[TABLE="class: grid, width: 500"]
First Name
[/td][td]Last Name
[/td][td]Vlookup
[/td][/tr][tr][td]John
[/td][td]Smith
[/td][td][/td][/tr][tr][td]Steve
[/td][td]Bailey
[/td][td][/td][/tr][tr][td]Dave
[/td][td]Woods
[/td][td][/td][/tr]
[/TABLE]