importing data from another table

  • Thread starter Thread starter melawaisi
  • Start date Start date
M

melawaisi

I have a table with 2 columns I and Z, the table is basic numbers. I
have, that has more columns, but has column with I and another with Z,
the second table has only one value which is I, how can I bring the
value from the other table into this table??? i have been trying the IF
command, but that goes on forever. i am saying =if(f8=q8, r8, if.....


thanks
 
Could you please rephrase your question
It sounds like you need Vlookup, but I'm not sure what you're trying to
do
 
melawaisi said:
I have a table with 2 columns I and Z, the table is basic numbers. I
have, that has more columns, but has column with I and another with Z,
the second table has only one value which is I, how can I bring the
value from the other table into this table??? i have been trying the IF
command, but that goes on forever. i am saying =if(f8=q8, r8, if.....
Click to expand...

Your post is very difficult, if not impossible, to follow. However, I
suspect you need to look at the VLOOKUP function. As a simple example, if
you had a table in A1:B10 and a value in D1,
=VLOOKUP(D1,A1:B10,2,FALSE)
would look up the D1 value in A1:A10 and return the corresponding value from
B1:B10.
See Help for full details.
I suggest you start with something simple like this to become familiar with
the function, and adapt it to your requirements.
 
I have 2 tables, each with 2 columns

Table 1 Table 2
cable z cable z

70 25 1.65
35 35 1.15
400 50 0.87
70 70 0.6
95 95 0.45
35 120 0.37
150 150 0.3
185 185 0.26
35 240 0.21
300 300 0.185
150 400 0.165
35
120
185
25
240
35
185



What i would like to do is to simply look into table 2, and take the
corressponding value for the cable and insert it into the first table
in the z column>>> i hope this is understandable.
 
Back
Top