lookup values

I have a worksheet that utilizes several functions to get data depending on other information. One “Category” inputs Mobile Phone based on the amount of a given month’s expense. This amount can vary as you can see by the attached Xl2bb. Is there some way whenever the monthly Mobile expense...

Hi, I have below table that I need to fill the Min-Max ranges from a different 2 tables/references based on ID. I have added the Expected results column but I need a formula that can give me these results. From below data: if ID is found in Range 1 table then give me the min & max for this ID...

Dear Community, I am in the process of building my first database for all kinds of lubricants that my employer sells. However, I am now stuck trying to figure out how I can import the data from excell into a dropdown list with 7 values total. These values are: Can, Spray Can, Pail, Drum, Drum...

I have an expense form that includes a mileage chart. I have "From Branch" and "To Branch" columns, each of which uses the same list of branches as data validation. <tbody> From To Mileage Main Ditch Road 12.51 The Other Branch Main 16.86 </tbody><colgroup><col><col><col></colgroup> I...

Hi, I am looking to run Vlookup formual for below table from the 3 subsequent tables (Alpha, Bravo & Charlie) below for each month with each sub columns such as Alpha, Bravo and Charlie. Request your help in creating a Macro coding to avoid manual vlookup to fetch data in the first table...

Hi, How is it possible to search for data on a page using 2 lookup values in vlookup rather than just one? E.g. <TABLE style="WIDTH: 85pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=114><COLGROUP><COL style="WIDTH: 21pt; mso-width-source: userset; mso-width-alt...