Excel-Finding a numeric value return from a text drop box and return a value

[BobNoExcel]

Hi all,

Firstly, I know nothing about excel formulas, I’m trying to return numeric values by selecting “cash” or “card” in a drop down box with this text that would return a value from multiple rows or cells with the return value, This is a cash book spreadsheet with July to June tabs, any help would be appreciated.