Thanks Anne

I didnt even think it would be that easy. You are a star


Jeanette


"Anne Troy" wrote in message
news:df60$42dc09e7$97c5108d$11924@allthenewsgroups .com...
You should be able to, yes. Something like...

=vlookup(....)*a1
Where a1 contains the number of hours worked.
*******************
~Anne Troy

www.OfficeArticles.com


"jeanette.rimmer" wrote in message
...
Hi, Anne

Ive set this up so that I can pick up the pay rate from a lookup table
for
a
combination of contract and paying agency. I now need to multiply the
value
that this look up has given by the hrs that the person worked.

Can I do this with Vlookups? and a sum?


Confused


Jeanette

"Anne Troy" wrote in message
news:195ea$42d641ee$97c5108d$7123@allthenewsgroups .com...
I have done this a few times. In my lookup table, I create a 3rd column,
where I put =A1&B1. This strings 2 values together.
Then you can do a vlookup for A2&B2.
*******************
~Anne Troy

www.OfficeArticles.com


"Mostafa" wrote in message
...
Hi
I know the Vlookup formula
=VLOOKUP(A2,B5:C10,2,FALSE)
Can we change the lookup value ( A2 )
To two cells
Thanks