Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel DB alike?
Hi!
An amateur question: can someone help me getting a good tutorial or the neccesary information for filling row B automatically depending on the data on row A? For example: If row A says: Dog Carrot Apple Orange Cat Horse I would like row B to be automatically filled with: animal vegetable fruit fruit animal animal * Notice that the order on A doesn't follow a pattern Thanks! SSJ |
#2
|
|||
|
|||
You need the Vlookup function for this.
Check out the Excel pages at www.nwarwick.co.uk where you will find a link to an easy to follow tutorial that you can adapt to your own situation. HTH Neil www.nwarwick.co.uk "SEOJAPAN" wrote: Hi! An amateur question: can someone help me getting a good tutorial or the neccesary information for filling row B automatically depending on the data on row A? For example: If row A says: Dog Carrot Apple Orange Cat Horse I would like row B to be automatically filled with: animal vegetable fruit fruit animal animal * Notice that the order on A doesn't follow a pattern Thanks! SSJ |
#3
|
|||
|
|||
Hi
if you have a table somewhere in your workbook that lists the options and what they relate to, then in your column B you can use the VLOOKUP function to create the table (say on sheet 2) type ..........A..............B 1.....Object.....Classification 2.....Dog.........Animal 3.....Cat..........Animal 4.....Horse......Animal 5......Carrot....Vegetable etc then on sheet 1, in cell B2 use the following formula =VLOOKUP(A2,Sheet2!$A$2:$B$5,2,0) which says, find the value entered in A2 in the first column of the table in sheet 2 and return the associated information from the 2nd column where there is an exact match. If there is no match or nothing in A2 the formula will return a #NA error - to deal with this =IF(ISNA(VLOOKUP(A2,Sheet2!$A$2:$B$5,2,0)),"",VLOO KUP(A2,Sheet2!$A$2:$B$5,2,0)) this formula can then be copied down for all rows in column B -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "SEOJAPAN" wrote in message oups.com... Hi! An amateur question: can someone help me getting a good tutorial or the neccesary information for filling row B automatically depending on the data on row A? For example: If row A says: Dog Carrot Apple Orange Cat Horse I would like row B to be automatically filled with: animal vegetable fruit fruit animal animal * Notice that the order on A doesn't follow a pattern Thanks! SSJ |
#4
|
|||
|
|||
Thank you guys!!!!
SSJ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
html to excel | Excel Discussion (Misc queries) | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Merge from Excel to Excel | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
Shortcut file fails to open | Excel Discussion (Misc queries) |