Hi,

VLOOKUP(#,List,2,FALSE)

would look up a # in the first column of List and bring back the item in
column 2 if a match is found in column 1.

Cheers,
Shane Devenshire

"Lisa" wrote:

solved it

"Lisa" wrote:

On sheet 1, I have a list of item #'s referenced from sheet 2. I need to
return a cost on an adjacent cell in sheet 1 for the item # looked up.

any ideas?