Hello all,
I have a sheet with a drop down list made using data validation. The value selected in the drop down list functions as the lookup_value for a bunch of vlookups. I'd like to "protect" the sheet in some way as the users are not necessarily Excel savvy and I don't want the vlookups...
Hi all, Newbie with Excel and looking to create a dispatch database. I was told Vlookup was the function of choice. See table below:
What I want to do is have a 3 colums to the left of this hidden data with CITY, PRIMARY & 2NDARY as headers. A1 - City & Then B1 & C1 will provide the details...
Hello all,
I am trying to set up a worksheet that pulls information from another sheet. On sheet one I have columns starting with a date column (COL A). I am trying to get information from a second column (COL AA) to return to the second worksheet. However, the data in COL AA is not...
Hello experienced and talented Excel people.
Example. I am working for a company and I have segments, brands and variants.
Example:
Segment:Coffee, tea, chocolate
Brands: coffee--> Nescafe, ground coffee
Tea --> green tea, freshly cut leaf
Chocolate ---> white, dark, 100 cocoa
Variants...
What I have:
Sheet 1 has a list of tank_id's (no duplicates) called "Details" (Columns are Tank_id, Tank_Name, Nation, Turret, TArmor_front, TArmor_rear, TView_range..).
Sheet 2 has a list of Turrets and the specifications called "Turrets". (Columns are: Tank_id, Turret_id, Turret_Name...
Hi there,
I am stuck and maybe VLOOKUP is not the way to go at all but here is what I am trying to do.
I have a column where uses paste data ex: HP LaserJet 4014n Printer
I want to update this data with the Correct Product name from a different tab in the sheet. Table_Array 'Price List Jan...
Hi Excel Nation,
I am currently working with 2 lists of data on 2 separate worksheets. By using the project ID numbers and the phase specified by the corresponding column, I am trying to return the status of the phases' QA status. For the below example, I want to return the status of the...
Hi Guys,
Does anyone know how I can lookup the values in one row in sheet 2 (see tables below) and compare this with all rows in sheet 1?
If any of the cell values in one row in sheet 2 equal the values in any of the rows in sheet 1 then I would like to return the values 'TRUE' or 'FALSE' for...
I AM TRYING TO USE VLOOK UP OR ANY OTHER FORMULA THAT WOULD WORK WITH MY APPROACH.
FORMULA WILL LOOK UP THE DATE FROM MULTIPLE TABLES AND POPULATE 1ST AND 2ND VALUES FOR THE CATEGORiES BASED THE DATE VALIDATION NOTE IT WILL GO TO THE NEXT VALID DATE SEE EXAMPLE BELOW I AM SORRY IF I AM NOT...
Hi MrExcel Community,
See below for a sample of data that I need to extract information into a searchable database. All of the information is provided in both columns and rows. I'd like to create TABLE 1 into TABLE 2. What's most frustrating is identifying project type by finding the YES and...
I have 2 spreadsheets; the master has the server name and details as a distinct row. The other has all the applications on that server as multiple rows. I want to copy the multiple applications to the master spreadsheet by inserting a new row for each application and pasting that into the...
Hi,
this is driving me nuts. I want lookup 1 record-Op Number from a sheet and combine multiple instances onto the next sheet. Tried using Vlookup but only returns the first instance. Example:
<tbody>
<tbody>
Op Num
</tbody><colgroup><col></colgroup>
ID
<tbody>
2TT3...
Hi,
I need assistance performing a vlook up in a table where I would like the formula to look at the data in Sheet 1, Columns A & B and if they match the information in Sheet 2, Columns A & B (same data) go back to Sheet 1 and look at the status of Column C and return a value of Y for pass or N...
Hi
I am attempting to compare 2 columns in separate workbooks, and if a match is found, to return the data in columns 38-40 from one workbook into columns 38-40 of the second workbook. I thought the best way to do this was to progressively loop through the values of the column in WB1, and...
First off thanks for the help
I'm trying to use a variable for the VLOOKUP value. The below code works however it adds parenthesis around the VLOOKUP value, the result is it's not being recognized as a cell location. I have tried changing the variable types but have not had any luck.
This is an...
We have data pertaining to the amount and order we have recieved segregated based on location and mediums like Website and Facebook. I am building a summary sheets that will display selected information from the other sheet for a particular location. I tried using VlookUp but that does not...
Help...!!!!!
I'm needing a formula which will paste text into a cell if another cell is between two set dates.
For or example if A1 is between 2/4/15 and 12/5/15 A2 to show April
if A1 is between 13/5/15 and 10/6/15 I'd need A2 to show May... And so on.
I'd love to be to just format the...
Hello all -
First post, so please bear with me.
I am trying to write a VLookup formula as part of a cash forecast I am setting up. I am looking to pull daily bank balances (kept in a separate workbook) into my forecast for an opening cash position.
I can reference the Col_Index_Num and...
I need to pull data from 4 columns for ticket sales. The columns include:
- Date of Purchase
- Amount Paid
- Event Date
- Payment Method
I am trying to pull the amount paid based on the event date, date of purchase, and payment method to create general journal entries.
For example - I need to...
I have an attendance sheet that we will be using a barcode scanner to enter their invitation as they arrive.
The data I was given works fine with the following
=IF(B2="","",VLOOKUP(B2,'NAME LIST'!$A$2:$B$3000,2,FALSE))
With
<tbody>
*00361428*
</tbody>
As my barcode format
the...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.