Excel Formula

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
 
P

Paul Corrado

=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top