Functions which can be used any number of times in excel-2003

B

BHUVANESWARI.P

I have cell with data validation with 25 entries in the list in one sheet. I
want to have equivalent values in another cell of another hyper-linked sheet.
For eg: If I click a value of say '1000', I should get '2000' as value in a
cell of hyper-linked sheet. Like this, if I click any one of 25 values, I
should have respective (corresponding) equivalent value. My problem is I can
try with 'IF' function for only 7 times and 'Lookup' function for 13 times.
Now kindly me what to do?-EXCEL-2003.
 
B

Bob Phillips

Take a look at VLOOKUP in help, it should do what you want.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top