MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.