=IF(ISNA(MATCH($D$7,Sheet3!BV1:BV11,0))=TRUE,"",LO OKUP($D$7,Sheet3!BV1:BW11)
)

or


=IF(ISNA(MATCH($D$7,Sheet3!BV1:BV11,0))=TRUE,"",VL OOKUP($D$7,Sheet3!BV1:BW11
,2,False))
--
Regards,
Tom Ogilvy

"steve" wrote in message
...
thanks guys, how do i use vlookup if i put my table in a different sheet?

"STEVE BELL" wrote:

Steve,

If you can determine a mathmatical relationship - than you can just
build a
formula based on the value of D7. I build a scatter plot and found that
most of the values matched a powered trend line.

But the easiest would be to use a Lookup Table. (table = $BV$1:$BW$11)
=LOOKUP($D$7,BV1:BW11)

Note that it will return #N/A if D7 isn't found.

You can get around that with
=IF(ISNA(MATCH($D$7,BV1:BV11,0))=TRUE,"",LOOKUP($D $7,BV1:BW11))

Otherwise you can use a Case Select in code.

--
steveB

Remove "AYN" from email to respond
"steve" wrote in message
...
i use the following if statement in my sheet:

=IF(D7=3,0.376,IF(D7=4,0.668,IF(D7=5,1.043,IF(D7=6 ,1.502)))))

the problem is that 7 IF statements is the max, and i have 11 that i
need
to
use. do i need to switch to a macro? here is how the list goes. the
first
column is the size of the bar, the second column is the weight(pounds
per
foot)

3 .376
4 .668
5 1.043
6 1.502
7 2.044
8 2.67
9 3.4
10 4.303
11 5.313
14 7.650
18 13.6