Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup&inputbox
hi......very much a beginner here...but I have managed to put together a sub
that gives me a small table from an output of telesales operators calls....columns involve "calls made", "#sales", "total$" Each operator has 2 "2opnumbers" (not always the same each day) so I am now trying to put together a sub that allows me collate the info from the table using an input box to allow me to assign a name to each "opnumber".. from there lookup each op's credits, and sum the two credits for each op (does that make sense?) I've tried the following, which doesn't work. Would someone like to help? thanks user1 = Val(InputBox("Maureen, First Op#", 1)) user2 = Val(InputBox("Maureen, Second Op#")) mc1 = "=vlookup(user1,f8:j8,2)" mc2 = "=vlookup(user2,F8:J8,2)" Worksheets("opstats 154").Range("n4") = "=sum(mc1+mc2)" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
InputBox Help | Excel Discussion (Misc queries) | |||
InputBox with VBA | Excel Discussion (Misc queries) | |||
InputBox | Excel Discussion (Misc queries) | |||
Inputbox with VBA | Excel Discussion (Misc queries) | |||
Vlookup with an InputBox | Excel Discussion (Misc queries) |