Hi!

> This is a much simplified version, but...

And this is the simplified solution! <g>

=IF(ISNA(MATCH(lookup_value,A1:A5,0)),"",OFFSET(A1,MATCH(lookup_value,A1:A5,0),12))

Biff

"mendozalaura" <[email protected]>
wrote in message
news:[email protected]...
>
> Okay
>
> This is a much simplified version, but...
>
> How do I write a function statement that will:
>
> 1) Do a vlookup to find a value
> 2) If it finds the value then offset by 1 row and 12 columns and return
> the value of that cell
> 3) If the lookup value is not found then return a value of 0 or ""
>
>
> --
> mendozalaura
> ------------------------------------------------------------------------
> mendozalaura's Profile:
> http://www.excelforum.com/member.php...o&userid=16118
> View this thread: http://www.excelforum.com/showthread...hreadid=398342
>