S
Sam Hfz
im trying to link between 2 sheets as follows:
sheet 1 : table of 2 columns A & b, with 300 rows, table is filled
sheet 2 : same table but empty
i want to: fill data in sheet 2 , for example, ill enter 12 in cell A1 in
sheet 2, and i want excel to search for this value in column A in sheet 1, if
excel find that value in sheet 1 then it should reflect (B1 from sheet 1)
into (b1 in sheet 2), so what is the suitable formula i should put into
coloume B in sheet 2.
i tryed to use IF, but i have 300 rows, excel refused too long formula...is
there a direct order makes excell search for a value in a column?
thx for your help
i need this very urgent
thx again
sheet 1 : table of 2 columns A & b, with 300 rows, table is filled
sheet 2 : same table but empty
i want to: fill data in sheet 2 , for example, ill enter 12 in cell A1 in
sheet 2, and i want excel to search for this value in column A in sheet 1, if
excel find that value in sheet 1 then it should reflect (B1 from sheet 1)
into (b1 in sheet 2), so what is the suitable formula i should put into
coloume B in sheet 2.
i tryed to use IF, but i have 300 rows, excel refused too long formula...is
there a direct order makes excell search for a value in a column?
thx for your help
i need this very urgent
thx again