By using listi.net you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes
   dbr983 : -2147217900 The INSERT INTO statement contains the following unknown field name: 'dt_accessed'. Make sure you have typed the name correctly, and try the operation again.insert into listaccess (dt_accessed,list_id,userid,ip_addr) values ('12/7/2021 1:50:19 AM',37973,-1,'54.80.173.217')

listi.net

 


When VLookup goes wrong

VLookup is a Microsoft Excel function that allows you to convert 1 value to another by looking it up. An example is if you had the numbers of a bunch of baseball players and wanted to include their names.

On Sheet2 you have the following:

AB
1NumberName
21Bill Martin
32Derek Jeter
43Babe Ruth
54Lou Gehrig
65Joe DiMaggio
77Mickey Mantle
88Yogi Berra
915Thurman Munson


To include the VLookup code the following:

=VLookup(2,Sheet2!A:B,2,False)

blog comments powered by Disqus
   
Home | About | Feedback| Privacy | Terms of Service | @alecberg | FAQ | | Copyright © 2021 All Rights Reserved. Edit
This site uses cookies. If you don't want cookies and who doesn't want them as they're yummy, then leave.