looking up stuff =o(

Elainey · 01-06-2006, 03:45 PM

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 · 01-07-2006, 03:25 AM

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

DaveU

**wjohnson** · 01-07-2006, 03:45 AM

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,B1)
---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

looking up stuff =o(

LinkBack

Thread Tools

Rate This Thread

Display

looking up stuff =o(

Re: looking up stuff =o(

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions