looking up stuff =o(

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Elainey - 06 Jan 2006 19:42 GMT

i need some help looking and replacing some stuff up...i cant seem to
come up with a combo of functions that work. what about a macro?

I need to find A1 in column B, then replace that cell in B with the
corresponding value in C1 and so with over 500 values in column A.

for example...i have something like this:
    A    B    C
1    apple    apples    red
2    pears    grapes    black
3    bananas    plums    blue
4        pears
5        bananas

i want something like this:
    A    B    C
1    apple    red    red
2    pears    grapes    black
3    bananas    plums    blue
4        black
5        blue

can someone help me! =o(

Reply to this Message

Dave Unger - 07 Jan 2006 07:22 GMT

See the reply to your posting in comp.apps.spreadsheets

DaveU

Reply to this Message

wjohnson - 07 Jan 2006 07:45 GMT

Try this assume your current stuff is in columns A,B,C
Copy Column A and C to Column D and F
For your first example Prior to the formula
---A--------B---------C-------D-----------E---------------F
1--Apples---Apples----Red---- Apples----------------------Red

Enter the following formual into E1: =IF(A1=B1,C1)
---A--------B---------C-------D-----------E---------------F
1--Apples---Apples----Red---- Apples------Red-------------Red

Once you have all of the values filled in - then select all of Column E
- then Copy - then do a "PASTE SPECIAL" - "VALUES" this will eliminate
having to "Keep" your formula intact for the valuse in Column E. Then
do what you want with the columns

Signature

wjohnson

Reply to this Message