looking up stuff =o(

[Elainey]

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(

 

[Dave Unger]

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

DaveU

 

[wjohnson]

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