Jump to content
Posted 02 August 2005 - 06:54 AM
Posted 02 August 2005 - 09:29 AM
Edited by jgweed, 02 August 2005 - 09:16 PM.
Posted 03 August 2005 - 02:49 AM
Edited by hintswen, 03 August 2005 - 02:52 AM.
Posted 03 August 2005 - 06:31 PM
Posted 15 June 2006 - 11:57 AM
I'd add to this two more suggestions:
Try VLOOKUP or HLOOKUP. For example, type all the names in column D and all the values in column E. Select all the information in columns D and E. On the menu select Insert, Name, Define and enter a name like TheData. In column B1 enter the following formula:
Then copy the formula in B1 to the rest of the cells in column B.
0 members, 0 guests, 0 anonymous users