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