LebGeeks

Nabs

Member

Need help creating table

I don't know if this can be done in Excel. I know it can be done in Access, but I want an Excel sheet. OK, let's say we have 3 locations A, B, and C. We have the distances in numbers from A to B, A to C, and B to C. I want to write a letter in the first column, a letter in the next column, and the third column should give me the number corresponding to that distance. Doable in Excel?

Gamer

Member

Re: Need help creating table

excel is very flexible
but i dont follow your example nabs
kindly give more details please

but from what i understood
you can do it with functions of "IF" and "LOOKUP"

Last edited by Gamer (July 11 2013)

Nabs

Member

Re: Need help creating table

Look at the image below please:

http://imageshack.us/photo/my-images/89/5ziz.jpg/

Now, let's supposed the distance from A to B is 5 (whatever unit you like). I type A in the first cell, B in the second cell, and the answer 5 pops up in the 5th cell (in this case, we chose the answer to go there). Could work inversely too. B in first cell, A in second, the answer pops up. Now, the question is, where will Excel get the data from?

Last edited by Nabs (July 12 2013)

Gamer

Member

Re: Need help creating table

One Method come to mind is first make a table from cell A1 to B9
AA    0       
AB    5
AC    15                   
BA    5                   
BB    0                   
BC    10                   
CA    15                   
CB    10                   
CC    0                   

Second  assume that the cells D2 & E2 are fill in the letters
then choose a new cell to make a function of "=CONCATENATE(D2,E2)"
then choose another cell next to it with the function of "=IF(F2="","",LOOKUP(F2,$A$1:$A$9,$B$1:$B$9))"