ExcelBanter - If iserror help

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - If iserror help (https://www.excelbanter.com/excel-worksheet-functions/263805-if-iserror-help.html)

Help in nottingham

If iserror help

Hi can someone tell my why this does not work please, have used this combo
many times in the past

=IF(ISERROR(VLOOKUP(A2,A:B,2),0,((VLOOKUP(A2,A:B,2 ))

Sample data below

Eduardo

If iserror help

Hi,
first you are including the cell A2 in the range to be looked up, 2nd last
part was missing in the Vlookup, try

=IF(ISERROR(VLOOKUP(A2,A3:B100,2,FALSE)),0,(VLOOKU P(A2,A3:B100,2,FALSE)))

"Help in nottingham" wrote:

Hi can someone tell my why this does not work please, have used this combo
many times in the past

=IF(ISERROR(VLOOKUP(A2,A:B,2),0,((VLOOKUP(A2,A:B,2 ))

Sample data below

All times are GMT +1. The time now is 09:08 AM.