vlookup / if statement giving strange values

[bigdan]

EDIT - can one not attach a spreadsheet? if not, this whole thing can be ignored and i'll erase the thread. but im hoping it can. i know there's some kinda program i can download or code i can use as a workaround but im not interested in that, i want to upload my exact spreadsheet. please let me know.

----------------------------------------------------------

 

[scottylad2]

EDIT - can one not attach a spreadsheet? if not, this whole thing can be ignored and i'll erase the thread. but im hoping it can. i know there's some kinda program i can download or code i can use as a workaround but im not interested in that, i want to upload my exact spreadsheet. please let me know.

----------------------------------------------------------

only solution for a whole spreadsheet upload is use smething like box.net or pm someone and maybe they'll let you email it

 

[CharlesChuckieCharles]

if you use =Value(F1) that should change you text to values

Want better/faster responses to your questions?
Use Excel Jeanie to post samples of your sheet.