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