help me write function?

Z

Zach

I have an excel table which is pretty simple, but putting together code is
not one of my specialties. Each "record" is listed across a row, and each
column of that row is a characteristic. I need a function which lays out
like this: (things in quotes will be examples)

IF "D1=chicken" then "F1=cluck" or something to that extent. I tried using
Find and Replace, but it just gets too complicated the way i was trying it
before. Any help would be AWESOME.
 
B

Bernie Deitrick

Zach,

If cell F1, use a formula like

=IF(D1="Chicken","Cluck",IF(D1="Cow","Moo","Not a cow or chicken"))

I extended it because you wanted "something to that extent." <g>

HTH,
Bernie
MS Excel MVP
 
Z

Zach

awesome, those are both great. is there any way to make it apply to the
whole column at once?
 
B

Bernie Deitrick

Zach,

Copy it and paste it down your column to match your data. The D1 will change to D2, D3, etc.

HTH,
Bernie
MS Excel MVP
 
Z

Zach

It's perfect, thanks to you both for helping me out. Smooth sailing from
here on out.
 
Top