spresad sheet

E

excel challanged

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)
 
D

dlw

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF ERROR FORMULA 2
Excel Vlookup Help 0
Am I on the right path 8
Array Function to do a Sum of VLookUps that translate a letter gra 3
Formula Help 1
help on a vlookup please 5
formula help 5
Please help on formula that will not work (If-And formula) 3

Top