Question about Excel (SS8SATAS5128400R)
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
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
G12 = B12 =VLOOKUP(C1,Sheet2!A1:E300,3,FALSE)
Posted on Jul 20, 2008
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.
Posted on Jan 02, 2017
Tips for a great answer:
Mar 05, 2015 | Yahoo Computers & Internet
Feb 15, 2013 | Microsoft Excel for PC
Feb 20, 2012 | Stairmaster Exercise & Fitness
Mar 16, 2011 | Stairmaster FreeClimber 4600CL Blue...
Before you can attain your Motorola CLIQ's unlock code you will need the IMEI number on it. You can find the IMEI number by simply typing *#06# and hitting enter. This number is unique to all GSMphone and will help calculate your unlocking code. Once you have your unlock code you are ready to begun the Motorola unlock instructions posted below.
Here are the steps to unlock your phone:
Unlock Motorola CLIQ (SIM Unlock)
1. Reboot your Motorola CLIQ with an unaccepted SIM card in.
*If the display reads "Enter Special Code", enter the unlock code and press "OK"
*If the display does not read "Enter Special code":
2. Press and hold the * key until an entry box is displayed.
3. Type *, #, 3, 2, # and press "OK"
4. Enter your Motorola CLIQ's unlock code and press "OK."
5. Your Motorola CLIQ should now display either "Completed" or "Deleted"
Jan 01, 2011 | Motorola Mobility CLIQ Cell Phone
Oct 28, 2010 | Nokia 3110 Cellular Phone
Nov 12, 2009 | Nokia 6300 Cellular Phone
Jun 08, 2009 | Microsoft Office Excel 2003 for PC
Nov 20, 2008 | Computers & Internet
Apr 03, 2008 | Microsoft Access 2000 (077-01277) for PC
124 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: