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.