Forum Discussion

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 ...

Expenses.xlsx15 KB

excel

Formulas and Functions

Riny_van_Eekelen
Mar 01, 2021
Kindytreasurer That could be:
=IF($I3=J$2,$H3,"")
in J3. Copy down and across.

Riny_van_Eekelen

Platinum Contributor

Mar 01, 2021

Kindytreasurer That could be:

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

in J3. Copy down and across.

Kindytreasurer

Copper Contributor

Mar 01, 2021

Thank you so much, That worked perfectly!