Hi. I know this is the general question area, but I'm using Excel 2003 and there's no 2003 area.

I have a data set that I need to pull from. I have three columns. Columns A is text, Column B is numerical, and Column C is also text.

What I am trying to do is have a formula look over Column A and if Column A's text matches Column C's, then enter the corresponding numerical data from Column B. Columns A & B match so that A1 goes with B1 and so forth...

I hope this makes sense. Can anyone help me??