Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
use vlookup with offset function
I have a drop down menu when I selected a item (merchandise...) I want to
return three row and four columns (B to e) drop down menu merchandise Gasoline Food A B c d e merchandise john robert 500 40 4 .2% merchandise jeff gordon 800 90 4.5% merchandise julia robel 1000 90 6.5% gasoline mak dune 50 34 3,2% gasoline nancy thom 90 37 8.1% gasoline john good 200 34 5.4% food john 19 11 4.4% what is the formula when I used vlookup(merchandise ...) -- thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
offset within vlookup | Excel Discussion (Misc queries) | |||
Using Offset with Vlookup | Excel Discussion (Misc queries) | |||
Vlookup and offset function? | Excel Worksheet Functions | |||
Offset VLookup | Excel Worksheet Functions | |||
offset and vlookup | Excel Worksheet Functions |