spresad sheet
 

using the vlookup, ,,, =Vlookup(A1,COSTSHEET!A;C,2,FALSE) there seems to be
a problem with 2 , Lookup numbers ,, (ie), comming up #n/a for two item
numbers,
tryed other numbers there and they work in cells?

formula result = ( is blank)
others are formula results = milk, white 1/2 pt (etc)

spresad sheet
 

what are the item numbers? Could be they are text in one place and numbers
in the other.

"excel challanged" wrote:

using the vlookup, ,,, =Vlookup(A1,COSTSHEET!A;C,2,FALSE) there seems to be
a problem with 2 , Lookup numbers ,, (ie), comming up #n/a for two item
numbers,
tryed other numbers there and they work in cells?

formula result = ( is blank)
others are formula results = milk, white 1/2 pt (etc)

spresad sheet
 

both set as text ??

"dlw" wrote:

what are the item numbers? Could be they are text in one place and numbers
in the other.

"excel challanged" wrote:

using the vlookup, ,,, =Vlookup(A1,COSTSHEET!A;C,2,FALSE) there seems to be
a problem with 2 , Lookup numbers ,, (ie), comming up #n/a for two item
numbers,
tryed other numbers there and they work in cells?

formula result = ( is blank)
others are formula results = milk, white 1/2 pt (etc)