Hi,

I have Numbers 1 to 28 in Cells B6:AC6, and Values Associated with these
Numbers in Cells B7:AC7.
I ALSO have Numbers 29 to 56 in Cells B8:AC8, and Values Associated with
these Numbers in Cells B9:AC9.

How do I Create the HLOOKUP Formula in Cell S14 that Looks at the Value
in Cell K14 and then Returns the Value from the HLOOKUP Table. The
Formula Below Works But ONLY for the HLOOKUP Cells B6:AC7.

=IF(ISERROR(HLOOKUP(K14,$B$6:$AC$7,2)),0,(HLOOKUP( K14,$B$6:$AC$7,2)))

Basically, if the Value in Cell K14 is NOT Found in the Above Formula it
Looks in the Formula Below.

=IF(ISERROR(HLOOKUP(K14,$B$8:$AC$9,2)),0,(HLOOKUP( K14,$B$8:$AC$9,2)))

I have Tried Several Variations But to NO Avail.

Thanks in Advance.
All the Best.
Paul




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!