Replies

Fantastic! I will give a try!! Thanks so much!

Thanks to both of you; I will try both approaches 🙂

Ah! Good idea! Thanks!

RG, thanks so much!!

I realized I can combine the two columns (Fund + code) making it a unique value and then use VLookup.

Thanks, Kevin.

@MartinM, It’s a great suggestion! I’ve always avoided, will give it a try. Thanks.

Kevin@Radstock. What you provided is perfect! The results are as I desired. I attempted to copy into my original spreadsheet and change the range, but it won’t work? Any ideas why it’s not working?

The 2,316.38 is the balance that I must allocate into the funds. It’s not a sum balance.

So, there’s no other way around this other than using a Macro? I don’t use them.

Hi, Martin, thanks for getting back to me. Below is what I’d like to see: the fund numbers from table 2 matched to the appropriate names from Table 1.

My project is to transfer dollars from the 00001 (general) fund numbers and allocate to the various funds in table 2.

Names Fund Amount Fund assigned per Name
BHAGAT 000001 2,316.38 554102 554714
BONNEY 000001 3,666.67 554710 556627 556352
CARBERRY 000001 5,991.34 549666 559417 554266 552095

Yes!!! Thank you so much!!!

I think this is a part of my solution. will work with this to see if I can figure out the rest! Thanks!

Vlookup..didn’t know it could be used that way. I always thought an exact match was necessary. Thanks.

I wasn’t able to import the entire file because it was too large. Thanks for getting back to me.

Steve, thank you so much!!! Wow, please explain the formula.

Hello, Hans.

The formulas in the affected Column had the the worksheet name, cell column and row..i.e…..”Input!Bx”.
I’ve just noticed that all other columns w/cell references simply have the column & row…..”Ax”.