Hi,

I need to build a formula in a column I on Account_Setup worksheet within my workbook.

Firstly, it is based on whether Column H on the same sheet is <> blank "" (if Column H = blank then Column I = 1)
Secondly, if the value of column H is NOT blank, it will match a value found within a table held on a separate sheet (Setup_Tables H5:H54). The formula should return the value held in the adjacent column I from the Setup_Table worksheet).

I think its something like:

but I'm getting an '#N/A' error.


Any ideas? Hope this makes sense,

Thanks in advance,

__________________
Neal

A Northern Soul

I think I've found the answer. It should perhaps be:

Thanks anyway.

__________________
Neal

A Northern Soul