Sum Help IFERROR & VLOOKUP

[bloodmilksky]

Hi Guys, I hope you are all well.

I was just wondering if anyone could help me on the below please

=IF(ISERROR(F2)=TRUE,"N/A",VLOOKUP('Hidden Sheet'!H2,'Hidden Sheet'!I2:J176,))) It keeps on erroring under #VALUE but I am sure I have covered my bases.

any help would be great

jamie

 

[AlanY]

your vlookup is incomplete, the target column index is missing.

may be
=IF(ISERROR(F2)=TRUE,"N/A",VLOOKUP('Hidden Sheet'!H2,'Hidden Sheet'!I2:J176,2,0))

 

[AlKey]

Maybe this

=IFERROR(VLOOKUP('Hidden Sheet'!H2,'Hidden Sheet'!I2:J176,2,0),"N/A")

 

[Joe4]

You only have two arguments in your VLOOKUP formula.
The third argument (which column to return) is not optional, it is required.
https://www.techonthenet.com/excel/formulas/vlookup.php

 

[bloodmilksky]

too much caffeine and not enough concentration thank you guys