The value can be anywhere in the range in any column but would be unique. I
am familiar with vlookup but it only searches the first column.



"Tim Williams" wrote in message
...
Is the value being looked up located in a specific column within (eg)
A1:T15, or can it be anywhere in that range?

You can use vlookup() to return cells to the right of the searched
value (as long as you're only looking in a specific column)

If looking across columns, you could try using a combination
of .Find() and .Offset()

Tim

On Nov 11, 2:39 pm, "Jim Lavery" wrote:
Can anyone tell me how to look up a value (A20) in a range (example
A1:T15)
& return the value of the cell above & if possible the cell to the right.