| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup with .csv data
Try this =VLOOKUP(CDE,Sheet2!$A$1:$E$57,3,False) The $ sign makes the formula absolute reference, therefore when you drag it down the column the table reference stay the same. Other wise your formula will progressively get out of range A1:E57 will change to A2:E58 A3:E59 If you are using the Vlookup wizard after you enter the table range hit F4 to make the absolut reference other wise just add the dollar signs. Hope this work. Lostinformulas -- lostinformulas ------------------------------------------------------------------------ lostinformulas's Profile: http://www.excelforum.com/member.php...o&userid=35229 View this thread: http://www.excelforum.com/showthread...hreadid=565750 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup to Return a Range of Data | Excel Discussion (Misc queries) | |||
| .csv file Multiple columns of data in single Cell | Excel Discussion (Misc queries) | |||
| ranking query | Excel Discussion (Misc queries) | |||
| Vlookup for data contained in a cell | Excel Worksheet Functions | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Hybrid Mode
