reference table

I'm facing an issue with the VLOOKUP function when attempting to categorize my customers based on their values. I have a list of customer names in column A and their respective values in column B. Additionally, I have a reference table with categories in column G and their corresponding values...

Hi Everyone, I need some help with my code to reference the table properly. Right now, when I run this code, the data populates outside of the table - not sure how to reference the table correctly. Table = "PrevReport" Sheet = "Print Reports" The data is being filtered by date range from...

I have lots of Case Select scenarios set up. I'm going to have to add a lot more. A greatly condensed sample is below. How can I recreate this scenario using a reference table? Beginning on row 84 to the end of the data, it's comparing what's in column O (college names) to hundreds/thousands of...

I'm trying to perform a SUMPRODUCT of 2 columns where each value is text, but those text values correspond to numbers in a lookup table. There's an easy way to do this using hidden columns that perform the VLOOKUP part, but I'm trying to avoid any hidden columns. I know that the following...

Hello, Everyone! I have an issue that I desperately need help with. My boss told me to do this a while ago, and I have been struggling tremendously... I need to make an interactive spreadsheet (table) of employees. Each row will have a different employee, while each column will have a...

Hi, This might be simplistic - apologies! I have a Risk Factor reference table in 1 sheet: ↓Likelihood Consequence→ Major Moderate Minor Likely High High Medium Possible High...

Dear Forum, I have been looking around various forums, but did not find exactly what I am looking for... VB is not yet my strong point... Here is my situation/question that I am hoping to find a solution for in Excel and in VBA Context: Personal Budget. I export to excel the expenditures from...

Hi! I run multiple reports that give me data with the a country code rather than country name. I have a table of country codes and country names that I have referenced using a VLOOKUP, but was wondering what the most efficient way would be to save the Country Code table as an Add-On and run an...