| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup help
Thanks alot for your help!
Sincerely, Scott "Peo Sjoblom" wrote: I would avoid that if I were you, but if this is what you mean? =VLOOKUP(F2:F1001,A2:B50000,2,0) then you need to select 1000 cells, then enter the formula with ctrl + shift & enter it is better to use the first lookup value (in this case F2) then copy down 1000 rows =VLOOKUP(F2:F6,$A$2:$B$50000,2,0) (note the absolute reference to the table) since you can change a single formula whereas if you use the array version you can't change only a part of it -- Regards, Peo Sjoblom http://nwexcelsolutions.com "scott" wrote in message ... i would like to create one vlookup for a column of cells. is this possible? i tried by selecting the colum and entering the vlookup, but it only pertained to the first cell. i tried to enter the formalu, then copy and paste, but it returns a #REF! i would like to aviod entering a formula 1000 times. any ideas? thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP Problem | Excel Discussion (Misc queries) | |||
| Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
| VLOOKUP Limitations | Excel Worksheet Functions | |||
| Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
| vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Threaded Mode
