Excel Formula

  • Thread starter Thread starter Pha1c0n
  • Start date Start date
P

Pha1c0n

I need help with a formula that would do the following in Excel.

If Column A = Column C2 thru C10, then Column B = D2 thru D10.

C2 would need to match up with D2 and so on. Is this possible and how
would I do it. Column A and C would be text and B & D would be
numbers.

Thanks
 
=IF(A2=C2,D2,"Something Else")

Put in B2 and copy down. Replace the "Something Else" with whatever you
wish. "" will return a blank.

HTH

PC
 
Back
Top