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:
Aug 22, 2008 | Computers & Internet
Jun 16, 2008 | Excel (SS8SATAS5128400R)
Jan 25, 2008 | Computers & Internet
Jan 07, 2008 | Buffalo Technology HD-HG400LAN...
Oct 06, 2007 | NetGear SC101 (SC101500) 250 GB Network...
Aug 07, 2006 | Fastora NAS-104 (nas-104d) 0.25 GB Hard...
122 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: