Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: Any quick way for editing VLOOKUP formulas ?
Dear Sir,
I wish to lookup reference in B255:B550 for the columnar values from Day 1 to day 26 in table 1. Table 1 A B C -- AA Day 1 Day 2 Day 26 1 B129 XXX 2 H451 XXX 5 K987 XXX 250 T289 XXX Lookup Day 1 Day2 Day 26 255 L224 =Vlookup() 256 T189 550 B129 Usually I enter =VLOOKUP($B255,$A$1:$AA$250,2,False) at cell C255 and copy across to the last column at day 26. After that I need to change the column reference for formula for each day i.e. from 2 up to 27. Next I would copy the first row downwards to cover the entire block C255:AB550. After this I would get the result. This is a tedious task. Is there any method for the row reference to increase automatically as I copy the formula across ? Alternatively, is there any other more suitable formulas that I could use to make the work more easier? Thanks Low -- A36B58K641 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: Any quick way for editing VLOOKUP formulas ?
Remove $ (dollar symbol) in the formula..............
On Apr 4, 7:31*pm, Mr. Low wrote: Dear Sir, I wish to lookup reference in B255:B550 for the columnar values from Day 1 to day 26 in table 1. Table 1 * * * * * A * * * * B * * * * *C * *-- *AA * * * * * * * * * * * * * * * * * * * *Day 1 * Day 2 * * Day 26 * * * * * * * * 1 * * * B129 * *XXX * * * * * * * * * * * * * * * * * * 2 * * * H451 * *XXX * * * * * * * * * * * * * * * * * * 5 * * * K987 * *XXX * * * * * * * * * * * * * * * * * * 250 * T289 * *XXX * * * * * * * * * * * * * * * * * * Lookup * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *Day 1 * * * Day2 * * *Day 26 * * * * 255 * * * * * * L224 * *=Vlookup() * * * * * * * * * * * * * * 256 * * * * * * T189 * * * * * * * * * * * * * * * * * 550 * * * * * * B129 Usually I enter =VLOOKUP($B255,$A$1:$AA$250,2,False) at cell C255 and copy across to the last column at day 26. After that I need to change the column reference for formula for each day i.e. from 2 up to 27. *Next I would copy the first row downwards to cover the entire block C255:AB550. After this I would get the result. This is a tedious task. Is there any method for the row reference to increase automatically as I copy the formula across ? Alternatively, is there any other more suitable formulas that I could use to make the work more easier? Thanks Low -- A36B58K641 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 Editing/Modifying a link | Excel Discussion (Misc queries) | |||
Excel 2002: Any quick way of transposing data ? | Excel Discussion (Misc queries) | |||
Excel 2002 : How to quick copy similar cell content ? | Excel Discussion (Misc queries) | |||
Excel 2002 : Any Quick Sub Total Formula ? | Excel Discussion (Misc queries) | |||
quick books and excel 2002 | New Users to Excel |