[semidevil]

There is a couple of things i'm trying to do.

how do I use the vlookup function to return a value, but to do it in a specific cell? I.e, I want to always return the value to cell C1, for example.

if I have the following words on sheet 1

sheet 1
bob, joey, michael.

on Sheet 2, here are the values on the column to the right of the words

sheet 2
bob - 1
joey - 2
michael - 3


On sheet 1, the names are hyperlinked to a vlookup formula. I click on 'bob,' and I want to return '1' to cell C1. I click on 'joey,' and I want to return '2' to cell C1. I click on 'michael,' I want to return the value '3' to cell C1.

How do I do this? Is vlookup the best formula for this?

Another question I want to ask is, how do I clear cell C1, before I go to the next? Is there a formula for it?

i.e, if I click on 'bob,' it will return '1' to C1. Next I want to click on 'joey' to return 2 to C1, but how do I clear bob's value first?

[slurpee55]

Could you upload a sample of your file please? Just a bit confused here - just put it up and show in another cell (say D1) what you want to see.