In trying to use VLOOKUP with reports exported to Excel from Quick Books (MAC) VLOOKUP will not recognize the column headings as usable data unless I retype the number. I've tried reformatting, but no use, it has to be retyped to get the formula to work. Any work arounds would be wonderful.
Thanks