| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
Thanks that helps!
"Richard Buttrey" wrote: On Mon, 19 Sep 2005 11:19:08 -0700, "Matt Cromer" wrote: Is there something that I can type in the "return column" part of the formula that will make the formula dynamic as I copy it to the right it will return column 2, then 3 in the next column and 4 in the following column? Make the return part of the formula column() You might need to add in a constant if your data doesn't start in column A. e.g. =vlookup("whatever",myrange,column()-1) HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
| Using a Vlookup to return values in a data list? | Excel Worksheet Functions | |||
| how do I filter for 1 variable in multiple columns | Excel Worksheet Functions | |||
| Can vlookup return multiple matches in a single cell? | Excel Discussion (Misc queries) | |||
| Drop-down selection fills data across multiple columns | Excel Discussion (Misc queries) | |||
Threaded Mode
