I have a spread sheet with two tabs one called FY and another called CC. In the CC spreadsheet column A has a series of two digit numbers from 01 through 04 (with the leading zero) and column C has a series of numbers with no leading zeros; the numbers can be up to 4 digits. In tab FY column H has the same numbers as Column C in the CC tab. What I am needing to do is find the match from Column I in FY and Column C in CC and then have it take the informtaion in column A (cc tab) and combine it with the number it matches and put the result in Column H in the FY tab. The end result numbers in Column H should look like this:
02-0034
04-2458
02-0004
03-0123 etc.
I know this can be done but don't have the foggiest where to start. Appreciate any help you can give.
Thanks,
Texanite
02-0034
04-2458
02-0004
03-0123 etc.
I know this can be done but don't have the foggiest where to start. Appreciate any help you can give.
Thanks,
Texanite