We'll troubleshoot the problem, and see different ways to fix it. However, there is a problem - the result in every row is an #N/A error. In the data entry table, a VLOOKUP formula should get the category name, based on a product's category code. In this example, there is a simple lookup table, with category codes and category names. To learn the basics of VLOOKUP, and see more examples, go to the VLOOKUP Function page
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |