Match Formula

[Jeff Podgorski]

Hello,

I need a formula that will look for a match between two sheets and return the value,

If A2:A1000 matches '2011 Expense!'B2:B1000, then '2011 Expense!Q2:Q1000

Hope this is enough to build on.

Thanks

 

[NBVC]

Do you mean:

=VLOOKUP(A2,2011 Expense!'$B$2:$Q$1000,16,FALSE)

copied down?

 

[Jeff Podgorski]

Thank you!

do you mean:

=vlookup(a2,2011 expense!'$b$2:$q$1000,16,false)

copied down?