1st Set is sales data by retail store ( Unique ID = Store Number)
2nd Set is Salesforce Report "All Accounts with Store Number" via Excel Connector
I am trying to use vlookup to map SFDC Account ID to the 1st set from the 2nd set and it is not working. However if I re-type the "Store Number" info in the Salesforce report the vlookup formula works.
ANyone have any idea what I'm doing wrong?
1 respuesta
Hi Roger,
Actually the exported xls file is NOT a real Excel file. You will need to copy and past it as a vlues into your other excel sheet if you want to use it in your VLOOKUP's.
Best
Ven
