Search results for query: *

Hi there, I need to build a file in VFP 7 that was running in Access 2000/2002. Is it possible to import it into VFP7 or should I just start all over? Otherwise, is it possible to create a runtime version in Access to demonstrate it with others? thanks

Hi there, I have 2 scenarios that I want to cionvert my computed value to: if the value is greater than $xxx.50 then it should round to $xxx.90, if smaller than that, it needs to round down to $xxx.10 I've tried this: =IF(RIGHT(F2,3)>0.5,(LEFT(F2,2)+0.9),(LEFT(F2,2)+0.1)) but it is not...

Hi, I have a combobox that allows me to choose a value from a defined list. I then want to reference the value in the box to calculate a number of lookup formulae. I can't seem to reference the value in the cell properly. I added the cell reference to the actual cell I have the combo box...

can it be done? I can't be entering 5000 result vectors every time the selection changes - is there a way to identify it using this sort of formula? MATCH('Retail routing'!D3,'LCR RATES'!(CONCATENATE("A",MATCH(A5,ratename)))):(CONCATENATE("u",MATCH(A5,ratename))))))))),0)-1...

Here's what I want to do: lookup array = a58:u58 can I somehow use a concatenate command or something to identify the row number? ie: =CONCATENATE("A",MATCH(A5,ratename)) (this gives me the desired text: a58) Is there some way of using this nested in a formula to identify an...

here's my problem: =INDEX(vendorrates,MATCH(A5,ratename),MATCH('Retail routing'!D3,'LCR RATES'!D58:U58,0)-1) How can I look up the row and find the value if I don't specify which row to look for the value in (the red part) This returns the right info, but it's not dynamic enough - I can't...

Hi, I have a excel question: I have a column of names, and I can use a match (=MATCH(A5,ratename))(= row 58) to find the row number, but I need to find a value in that row and then return the value to the left of it - I can find the column number if I specify the row array (=MATCH('Retail...

I have 2 tables - both share Ratename and Key_c; I would like to use a combo box to search a list of ratenames and then automatically list the data from the second table that needs to be amended or changed - I can't seem to find the right data/suggestions in any info I have - please help :)

I have a massive spreadsheet where in many cases the formula gives a #NUM! result if there is not a value in each of the referenced fields corresponding to the formula. I don't know how to eliminate them. Please help |-0

I have an excel spreadhseet with a row of 5 that i need to check against. They show: 5, 4, 3, 2, 1, or , , 3, 2, 1, or , , , , 1,. I need to fill a box with the first of the values that is not blank - I have over 700 rows to fill, thus a formula would simplify it. Thank you :)

I have a row of 50 values, one has been located as the lowest of the 50. I need to find the label for the column to which it belongs. There has to be a simpler solution than 50 IF statements, but how? Thanks for your help :)

Hi guys & gals, sorry for the seemingly stupid question. Looks like I'm lost here. I have a set of tables that feed info to each other: vendors-table, country-code, rates-by-vendor I need to run a query against the Rates-by-vendor table which lists the same country up to 15 times with...