vlookup & data validation

I am trying to develop a rather robust engineering/architectural style hardware schedule using Excel and data validation tables. Due to the numerous options though, I feel that data validation tables will require far more maintenance than the benefit of developing this project. To work as well...

Hi All, I'm new to this forum and hope someone can shed some light on a statement. The problem that I have is I'm currently running an IF statement with a vlookup which is matching a text field with a date to return some date from a column on a different sheet. The issue is there are times...

Hello, all: I am attempting to build an inventory spreadsheet in Excel 2013 on Windows 7. I apologize if this has been covered in detail before, but a search of the boards and the rest of the internet yielded me nothing. I have generated named tables and ranges on Sheet 2 which fill drop-downs...

Ok guys and gals. My brain is fried. Firstly, let me say I do not know VBA. I know most formulas. I have a rather intricate spreedsheet and I have 99.9% of the formulas finished. So here is my finial delima for today: (E13) is the manual input Year in (YYYY) format (E14) Has a dropdown of...

<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody> Data Names SKU1 SKU2 SKU3 SKU4 SKU5 Ali 0 20 15 0 0 Butt 15 0 16 30 Adnan 0 25 15 10 15 </tbody> <colgroup><col width="64" span="2"...

Hello, I am using MS Excel 2010 . And want to create a macro that will edit a cell range based off two criteras . Meaning if cell = sheet name then look for list box item in cell range . user input "date" then search sheet ref and row ref to input data in matching cell. to further...

<TBODY> A B 1 15% Sentence1 2 10% Sentence2 3 50% Sentence3 4 30% Sentence4 5 50% Sentence5 </TBODY> <TBODY> Top Errors A B 1 50% Sentence3 2 50% Sentence3 3 30% Sentence4 </TBODY> Hey everyone and thanks for looking into my problem. I have a table above (1st on top)...

I have a VLOOKUP that is taking the value in a cell that has "*0026" and it is returning the value in the table for the value of "00026". In this case the two are not the same values there could be either or both in the lookup table. Any Ideas of how I can ensure that if "*0026" is not in the...

Hi All! I have a pretty big problem here, and never met something like this, although I am using Excel a lot even doing macros. I got a Big database from SAP. Namely 862 000 rows. Each have a Material Nr. in it, looking like this: 1156985-141-09 I have another Workbook which contains certain...

I have initial data in Worksheet 1. Each row has a specified status (Submitted or Outstanding). I'd like Worksheet 2 to self populate with certain data from only the rows that are marked as Submitted. I'd like Worksheet 3 to self populate with certain data from only the rows that are marked as...

Dear Gurus: OK, I've been trying to use a VLOOKUP or MATCH formula to determine if the country in column A is a Priority Market. Priority Markets is a tab with a list of 23 countries. I keep getting a #N/A error on all of the cells. I need to know which countries are the Priority Markets...

Hi All, I have a problem where I'm trying to find a formula for the following and don't know if I need to use a V-lookup, an IF statment or something else. I'm basically trying to say ; Sheet 1 A B C 1 From To Date 2 J330 J310 10/05/13 3 J330 J310 10/05/13 4 J330...

this is my first attempt at anything like this, i am wanting to link two workbooks together with the aim that when a option is selected in a drop down menu in workbook "band form", it auto populates the rest of the form with data from the second workbook "showsales2013". date, ticket price...

dear experts, greetings to all, Created Data Validation on cellS C8 & C11 using values from range D3:D5.When i select the value from data validation list on Cell C8, the CHOOSE,COLUMNS and INDIRECT functions are giving only one correct value (i used Ctrl+Shift+Enter) and are giving VALUE error...