|
Central Nebraska | I built a excel sheet to record my spraying info on. I changed sprayers from Ag Leader to a Pro700 and miss the record keeping of the AL so i modeled my page after the Direct command reports. I used the list function for fields, nozzles, wind direction, and crops. I also made a table with all of my spray mixes that would load when I select the mix I'm running. I used the Vlookup function to bring this data to the form. It seems like it will only bring the correct ingredients for about 4 mixes and the rest bring in the wrong ingredients. I've used this function in my master calving books to pull data for a certain cow from each year's book and compile it in 1 book and it works flawlessly. I've tried to change how the spray mix gets it list and changed how some of the names where wrote in case excel was getting confused. I am out of ideas. I have attached the file below.
Thanks
Mike
Edited by white caddy 9/13/2023 07:29
Attachments
----------------
 Sprayer record master - Copy.xlsx (15KB - 174 downloads)
| |
|
help with excel lookup function
