On Sat, 19 Nov 2005 06:59:02 -0800, Kim wrote:

Hi again, okay C29 is general, there is no formula and I checked the cell.
I got the error by doing an "insert function" and a box came up with the
following:

Function Arguments
lookup value= c27,1=5
table array=sheet 2a1:a51=ref,ref,ref
col.ind.num=match,sheet1!c29,sheet21a1:e1=#n/a

Kim

If you are getting those results, it looks as if you pasted in the wrong
formula into C31. The formulas are wrong. Nothing on any of those lines that
you pasted matches the formula I posted.

Try the following:

1. Select the formula below; then Edit/Copy

=VLOOKUP(CEILING(C27,1),Sheet2!A1:E51,MATCH(Sheet1 !C29,Sheet2!A1:E1))

2. Select Sheet1!C31
Place cursor in formula bar at the top of the worksheet.
Edit/Paste
<Enter

See what you get.

If, after doing the above, you hit Insert/Function, what you *should* be seeing
is:

Lookup_value CEILING(C27,1) =5
Table_array Sheet2!A1:E51 ={"Weight","51","52",
Col_Index_num MATCH(Sheet1!C29,Sheet2!A1:E1) =3

If you con't see that, change it so you do.



--ron