Clever, but I'm curious why you don't use VLOOKUP? It's simpler, and Lotus 1-2-3... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

taviso on Aug 4, 2021 | parent | context | favorite | on: Spreadsheet formulas for personal finance

Clever, but I'm curious why you don't use VLOOKUP?

It's simpler, and Lotus 1-2-3 doesn't have MATCH! :-)

I think something like this would work...

    (income-@VLOOKUP(income,table,1))*@VLOOKUP(income,table,3)+@VLOOKUP(income,table,5)

basseq on Aug 10, 2021 [–]

Habit, mostly: I tend to use VLOOKUP for exact matches and MATCH for relative ones.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact