Vlook up not working
I am trying to create a table invoicie with Data on one sheet and charge slip on another sheet but i enter the formula and it keeps return N/A in fields can seem to find out why
I've looked through the spreadsheet you give and cannot find any "N/A" errors. Or even text. Every VLOOKUP() formula I found works exactly as one would expect it to as written. No errors,
In fact, the place the spreadsheet opens has VLOOKUP() functions in use and the logic of them seems to be meant more for verifying the lookup data DOES exist in the table. Rather than the usual idea of finding something other than the lookup data itself: If the data item is present in the table, the formula returns the data item which it coulddd do by simply referencing the lookup cell (like "=A33"), no need for the VLOOKUP(). Since it DOES do the lookup, it sort of looks like the logic is to see if it exists in the table or does not exist in the table. So it can be added if it doesn't, or be corrected if mis-typed. I guess.
That implies the logic of the writer was that you'd see an error and you would know you had to go right then to add the information line in the lookup table. In other words, as if it were meant to prompt and remind you to do the housekeeping. Once done, the error would go away. Presumably OTHER information in the line of that table would be used elsewhere so it is probably important to make sure you do the work.
That further implies that the errors are a GOOD THING as they let you know to correct the base entry if mis-typed, or to add the appropriate information into the underlying data table so other places that depend upon it (and almost certainly are not visible from this place) do not fail with their own errors which you might never notice.
If so, the errors are a good thing, and will go away naturally once you correct their input datum entry or add the line of data to underlying table.
In any case, can't help otherwise as I cannot find an error much less the ones you refer to.