Forum Discussion
Help with assigning account codes to one table from another table
Yes, I meant under <Account code range> $H$5:$H$100, <Name range> - $C$5:$C$100, etc.
It's always better to attach small sample file with/instead of screenshort. Very few people will type data manually from screen picture into the file to illustrate how formula works on real data.
SergeiBaklan , thanks, Sergei, for you continued help. When I input the formula in the 'Account Code' column, it returns a blank. What I'm trying to do is have the formula return, for example, '6300' in cell D5, '6900' in cell D6, etc. Could you show me how to do this? Please see attached the sample file.
Sorry, I forgot to mention you shall use it as an array formula, i.e. enter with combination of Ctrl+Shift+Enter instead of Enter. Result is
and in attached file
SergeiBaklan That worked. Thanks!!
Gsurfer210 , you are welcome