Question about Excel (SS8SATAS5128400R)

1 Answer

HELP with macro config

I would like to type an account number into cell B15 so if B15= (10023) then the other cells must automaticaly display as follows B12=name & G12=po box 1234 G13=city G14=postal code B16=vat nr and G15= terms
If I type a difrent number into B15 The other cells must change acordingly
this is for excel 2007

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that hasĀ over 10 points.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 18 Answers

Hi Hss Holdings,

The easiest way to do this is to use a formula called vlookup. You need to have the raw data some where in the workbook, but it can be a separate sheet. Put all the raw data in a table, make sure the account number is on the furthest left column, then start entering the formulas

vlookup(value_to_find, table_to_check, column_index_number, range_lookup(true/false))

value_to_find = the value you want to find on the left most column of the table
table_to_check = the table you want to find the data from
column_index_number = the column number of the data field you want to return into this cell, 1 = the left most column.
range_lookup = false for an exact match, true for the nearest match

Say the table is on sheet2 between A1 and E300

B15 is whatever you type, so no formula needed here
B12 =VLOOKUP(C1,Sheet2!A1:E300,2,FALSE)
G12 = B12 =VLOOKUP(C1,Sheet2!A1:E300,3,FALSE)
etc

Posted on Jul 20, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

Excel formula creation


= (a3) minus (b3) won't do it for you?

Sep 05, 2008 | Excel (SS8SATAS5128400R)

1 Answer

EXCEL


You will need to write a Macro that questions each position and turns it into a word depending on it's value ...

Something like :

DIM WordValue as String
DIM LenghtIndex as integer

FOR lenghtindex = 1 to Len(ExcelCellValue) DO

CASE StrCpy (Number, LenghtIndex , 1)
1 : WordValue = WordValue & "one"
2 : WordValue = WordValue & "two"
3 : WordValue = WordValue & "three"
4 : WordValue = WordValue & "four"
END CASE

END FOR

If you want it to realy say fourthy four when the value is 44 instead of have it say "four four" you need to question the position. If it's in second position starting from left it will be fourty , if it's in third place it will be fourhundred ... etc

Aug 22, 2008 | Computers & Internet

1 Answer

Prevention of delition of cell which has a formula


If you right click the cell in question and go to Format Cells..., on the protection tab there should be a check mark in the locked box. Go to the tools menu and choose Protect and Protect Sheet, enter a password and your cells will be protected.

Any cells you want to allow changes to when the sheet is protected should have the Locked checkmark removed.

Jun 16, 2008 | Excel (SS8SATAS5128400R)

1 Answer

To turn hours and minutes into decimal


Let's say that the time is in cell C3.
Now in cell D3 type =C3*24
then format cell D3 as Number.

Hope this helps.

Apr 24, 2008 | Excel (SS8SATAS5128400R)

3 Answers

Excel password removing


could you please supply us with the version of Excel you are using? it's under Help About Excel

Mar 04, 2008 | Excel (SS8SATAS5128400R)

1 Answer

Excel formula


Assuming that all of your data is in a single row number 4 and between columns N and PF

Try:
{=OFFSET(N4,0,MATCH(TODAY(),N4:PF4,0)+1,1,1)}

The MATCH function looks up the value of today() in the range N4 to PF4 and returns the number of columns offset from the beginning of the range. (The 0 here does an exact match)

The OFFSET function returns a value from a cell a specified number of columns from a reference cell, in this case N4, which is the first column that contains the search data. We need to add on to this value to skip the Interest column.

Regards,
Daryl

Jan 25, 2008 | Computers & Internet

1 Answer

Cannot Access Shares


Log on the computer to "administrator" account both system will see each other. To do this:

when computer prompted to type your password , Simultaneously press" Ctrl+Alt+Delete" 2 times and you'll prompted to type the username: Just type "administrator" and then enter(note: applicable if the the administrator username has no password.)

any problem regarding the solution please notify me for further information.

Jan 07, 2008 | Buffalo Technology HD-HG400LAN...

1 Answer

Netgear SC101 Firmwere failed upload


Check your password, when i first did it I used what i thought was my password and the password check passed but i couldn't do a manual or automatic update. I retried with the system default password and the automatic update worked.

Oct 06, 2007 | NetGear SC101 (SC101500) 250 GB Network...

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

122 people viewed this question

Ask a Question

Usually answered in minutes!

Top Excel Computers & Internet Experts

Brett Duxbury
Brett Duxbury

Level 3 Expert

2908 Answers

Bill Boyd

Level 3 Expert

33229 Answers

Lala

Level 2 Expert

34 Answers

Are you an Excel Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...