Vlookup

I was involved in a discussion on linkedin about vlookup , one of the contributions which I tested simplifies the formula

Instead of
=IF(ISERROR(VLOOKUP(“A”, Table,1,FALSE)),0,VLOOKUP(“A”, table,1,FALSE))
Try
=IFERROR(VLOOKUP(“A”,Table,1, FALSE),0)

1 reply

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply