Forum Discussion

Kindytreasurer's avatar
Kindytreasurer
Copper Contributor
Mar 01, 2021
Solved

Excel help with LOOKUP

HI,

 

I ahve a spreadsheet which logs and tracks our expenditure. I have setup a drodown list in I3 which is the category inwhich the expense is to be allocated to. What i would like to do is when you select your expense category form the drop down list it the auto fills to corresponding cell with the value from cell H3. Is this possible to do so? Also the cells in row 3 that are mpty need to either display a 0 value or remain empty. Thnak you

Resources