If, Then Formula

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??

Will this formula look through the entire range in A? C1 won't always coincide with A1... C1's match might be all the way down the list in A27, for example...

I've attached the file. Basically I have a "master" list of items and their count. I then have a second list compiled that is an abbreviation of the first. I would like to apply the count for the second list as well, without having to use the Find feature. All words in the second list are in the first list, but not vice-versa.

What I need is a formula that will look through the range in Column A, and if the word in Column F matches a word in Column A, the corresponding number in Column B is entered.

Does that make sense?

Thanks. that worked!