![]() |
|
#4
|
|||
|
|||
|
Quote:
=vlookup( < the formula which we will write in D1 =vlookup(The reference cell that the vlookup looks for in this example we will say A1 =vlookup(A1,Now you need to tell the formula what table to look in we will say b1:c12 in cell B1 type 1 B2 2 B3 3 etc., then in cell C1 type Jan then in C2 type Feb, C3 Mar etc. =vlookup(A1,B1:C12 Now you tell the formula what column of the table to look in b1:c12 only has 2 columns but we want to look into the 2nd one so we would write 2 =vlookup(A1,B1:C12,2 Last part do you want the formula to find an exact match only or get something closest to it. 0 is an exact match and 1 is find the next closest. So it you put in 1.7 in A1 the vlookup will give you the value of 2 which will say Feb in our example. =vlookup(A1,B1:C12,2,0) There it is let me know if you have any questions or if you want me to try and correct your formula to Vlookup. Thanks |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Calculation within Cells
|
manich1 | Excel | 2 | 12-07-2011 02:59 PM |
Excel Calculation Problem
|
UnholySmoke | Excel | 2 | 09-14-2011 08:15 AM |
Help with 'hours worked' calculation...
|
Snvlsfoal | Excel | 1 | 08-11-2011 05:54 AM |
Excel 2010 formula rounds - arithmetic average calculation
|
YooNaa Kim | Excel | 1 | 06-07-2011 08:50 PM |
Mail Merge Calculation Error
|
Lsbutler2000 | Mail Merge | 1 | 06-22-2007 06:33 AM |