Search results for query: *

Thanks. Through that I've managed to make both parts of this work - but only separately. I can get the results of the Department dropdown (Sheet1) from A1 in A2 using: =INDEX(Sheet2!B1:B3,MATCH(A1,Sheet2!A1:A3,0)) I can get the results of the Code dropdown (Sheet1) from B1 in B2 using...

Ok, this is as far as I've got: In Sheet2, I've named the range A1:B3 as 'Costc' In Sheet1, in cell A1 I've created a Data Validation as List, with the source "=Sheet2!A1:A3" i.e. the first column of 'Costc' in Sheet2. Still in Sheet1, in cell B1 I have the formula "=IF(A1="", "", VLOOKUP(A1...

I've given that a go too, but after hitting my head against a brick wall for a few days on this, I think I'll just merge the two columns and make do with a Data Validation lookup on the single column. Thanks anyway.

Hi, I've been searching the net for an example of my problem, but alas I can't find it. Basically I need to select a department name and related code number on a dropdown on a main page (Sheet1). To do this I need to be able to either select the name, or the code, on the two lists located in...

There's always more than one way of solving a problem so I did this method. On Sheet2 I put both formulas in separate cells. I modified each as follows: In box A1: =IF(ISNA(MATCH(Sheet1!D1,Sheet1!B:B,1)*1),0,(INDEX(Sheet1!A:B,MATCH(Sheet1!D1,Sheet1!B:B,1),1))) This gave me the result of the...

Thanks, after changing the first bit, it worked perfectly! =INDEX(A:B,Match(D1,B:B,1),1) Now if I wanted to have another column, using the same rows, i.e: E F G 1 11 514 590 2 12 591 634 3 13 635 720 4 14 721 800 Then I should be able to do...

Hi, I'm trying to search between two sets of data across multiple lines. (That's not very decriptive, so I'll give an example) A B C 1 1 1 259 2 2 260 322 3 3 323 460 4 4 461 513 In D1 I have a search box. The idea being, if I put say 280 in D1, I'll get...

I've cracked it - I was confused until I realised the references were pointing to the original set. It works now - great. Rather than place the formulas into the labels, I've put them on a separate sheet and linked the labels to them - in case I need to change one for whatever reason - in which...

I think I'm going to have to, as the 400 textboxes will be a nightmare especailly as I just can't understand how to relate the file fields to the fields in my labels. Whereever I put the formula I get one result which is either "NA" or "0" I think I'm going to have to push for the case of...

Ok. I've amended your code to reflect the data on my sheet. There is a frozen pane area above where this starts which contains data that is static on the Labels sheet. This is why it starts at A16. I did that to avoid repetition of data. A D G JKLM N Q T...

Thanks for that, I've put the (modified to my positions) formula into cells, and told the labels to refer to those cells but I get "#NA". Is there a specific place I need to place them? Thanks.

That is spot on. The ticks determine the position of the labels - this way I can reduce wastage. I'll never need more than 4 labels at a time (L7171 sheets only have 4) The data will never need sorting as there'll never be more than 100 files per year. Each year I'll simply copy the sheet and...

The descriptions of the first 2 are spot on - only the labels aren't numbered as such - the number is determined by what's selected on the 2nd sheet. The 3rd sheet has just 4 rows, where the labels take their data from. The idea being that whatever 4 boxes are ticked on the 2nd sheet will copy...

Thanks for that. I'd perhaps explain better what I'm trying to do as it's a bit fiddly. Unfortunately I can't copy a row because I'm using two separate colums of data on the page one is 1-50, the other is 51-100. These represent box files. A couple of row examples from 'Data' File TransFrom...

Hi, I have a database sheet 'Data', where I wish to add 4 buttons/checkboxes to each row of data. The idea being that I can check only 1 of the 4 per row, up to any 4 rows and this data is then passed to my other sheet, 'Labels'. The label sheet contains four spine labels based on L7171 Avery...

Now if I was to put the names in a separate table, called Employees, then link it to a field called NameID in the Loans table, presumably I would need an INNER JOIN for this query, yes ?

Thank You - once I'd put all the fields in (instead of the .*) it worked !

Hi, this is a bit of a biggie, but I was wondering if anyone could help please. I'm creating a database for loans of season tickets and I'm having problems with calculated fields in a query. The Database is based on a spreadsheet, which goes like this: Name AmtofLoan PeriodLoanPaid...

Thanks. Unfortunately, I've been unable to find a working example that I can apply to my database. Regards,

Hi, I was wondering if anyone can help please. I'm using a report based on Avery 7171 labels. I have 12 text boxes on the report, each set at Arial 30 Bold, which basically allows for 8 characters width. My form is also set this way for consistency and is based on a table with the 12 fields...