Hi,
I wanted to know if it is possible in Excel that if I typed a text in a cell
(A1), it will automatically look that text in another worksheet's column and
transfer the whole data in the row? for example: in worksheet A, the data in
column A1=ML120B, B1=BATTERY CHARGER, A2=XT6940, B2=CELLPHONE, A3=0058BLK,
B3=WIRELESS
Then if I go to worksheet B and type in A1=XT6940 the column B1 will
automatically have CELLPHONE in it. means that if I typed XT6940 it will find
the text in worksheet A column A and automatically search the corresponding
column B
Please anybody tell me.
Thanks,
Ariel in LA

Hi

On worksheet ResultTable
=VLOOKUP(A1,SourceTable!$A$1:$X$1000,2,0)
returns the value from column B on worksheet SourceTable, where in column A
first occurrence of same value as in ResultTable!A1 is found on same row.

The value you search (1st parameter in formula) for must always be in the
leftmost column of lookup range (2nd parameter, SourceTable!$A$1:$X$1000 in
example above)
The 3rd parameter determines the number of column in lookup range, from
where the result value is returned. NB! this is relative column number, i.e.
when the lookup range is p.e. Sheet1!$M$2:$T$100, and 3rd parameter is 3,
then the value from column O in Sheet1 is returned.
4th parameter set to 0 or False forces the formula to search for exact
match. When the exact match for search value in left column of lookup range
is not fount, an error is returned. So when you foresee that such occassions
can occur, you have to think about error trapping in your formula, like:
=IF(ISERROR(VLOOKUP(A1,SourceTable!$A$1:$X$1000,2, 0)),"",VLOOKUP(A1,SourceTa
ble!$A$1:$X$1000,2,0))


--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"Ariel in LA" <Ariel in wrote in message
...
Hi,
I wanted to know if it is possible in Excel that if I typed a text in a
cell
(A1), it will automatically look that text in another worksheet's column
and
transfer the whole data in the row? for example: in worksheet A, the data
in
column A1=ML120B, B1=BATTERY CHARGER, A2=XT6940, B2=CELLPHONE, A3=0058BLK,
B3=WIRELESS
Then if I go to worksheet B and type in A1=XT6940 the column B1 will
automatically have CELLPHONE in it. means that if I typed XT6940 it will
find
the text in worksheet A column A and automatically search the
corresponding
column B
Please anybody tell me.
Thanks,
Ariel in LA