Probably a stupid question
Posted by neil on January 07, 2002 6:15 AM
Is there a function which would allow me to just type in a refence code " ie. Js4" which would then input two set numbers " ie 234.722" and " 545.125" into a specified cell, and also allow me to type in different reference with different results
Posted by Dank on January 07, 2002 6:53 AM
There are several ways you can do this. Perhaps the easiest way is with the VLOOKUP function. Try this:-
In a sheet1 enter your reference codes in column A and your two set numbers in column B. For the sake of simplicity just do 5 rows. In sheet2 enter your reference number in cell A1. Now, in the cell where you want the two numbers to appear type =VLOOKUP(A1,Sheet1!A1:B5,2,FALSE)
You can find info about this function in Excel's help file.
I hope this gets you started...
Daniel.
