Is there a Formula for Mapping?
If I create a Mapping sheet that defines the relationship between each P&L account and its corresponding mapping code, can I then use the P&L account in cell C4 as a lookup value to return the correct mapping code?
In other words, I want Excel to search for the P&L account from C4 within the range Mapping!$B$2:$T$21, and if the P&L account is found, the formula should return the associated mapping code from that same row.
After some time it worked to a surtain point, as i can not understand why it doesen't accept surtain values and fill them in if they are found withing the range.
Mapingsheet Created;each P&Laccount stated in diffrent colum
In other words, I want Excel to search for the P&L account from C4 within the range Mapping!$B$2:$T$21, and if the P&L account is found, the formula should return the associated mapping code from that same row.
After some time it worked to a surtain point, as i can not understand why it doesen't accept surtain values and fill them in if they are found withing the range.
Mapingsheet Created;each P&Laccount stated in diffrent colum
0 answers ( 0 marked as helpful)
Submit an answer
