SOLVED

Excel help with LOOKUP

%3CLINGO-SUB%20id%3D%22lingo-sub-2174353%22%20slang%3D%22en-US%22%3EExcel%20help%20with%20LOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2174353%22%20slang%3D%22en-US%22%3E%3CP%3EHI%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20ahve%20a%20spreadsheet%20which%20logs%20and%20tracks%20our%20expenditure.%20I%20have%20setup%20a%20drodown%20list%20in%20I3%20which%20is%20the%20category%20inwhich%20the%20expense%20is%20to%20be%20allocated%20to.%20What%20i%20would%20like%20to%20do%20is%20when%20you%20select%20your%20expense%20category%20form%20the%20drop%20down%20list%20it%20the%20auto%20fills%20to%20corresponding%20cell%20with%20the%20value%20from%20cell%20H3.%20Is%20this%20possible%20to%20do%20so%3F%20Also%20the%20cells%20in%20row%203%20that%20are%20mpty%20need%20to%20either%20display%20a%200%20value%20or%20remain%20empty.%20Thnak%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2174353%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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

2 Replies
best response confirmed by Kindytreasurer (New Contributor)
Solution

@Kindytreasurer That could be:

=IF($I3=J$2,$H3,"")

in J3. Copy down and across. 

Thank you so much, That worked perfectly!