inputbox and vlookup - from a rank beginner

Giganews Newsgroups
Subject: inputbox and vlookup - from a rank beginner
Posted by:  Peter (~gleesonpet…@optusnet.com.au~)
Date: Thu, 13 May 2004

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)"

Replies