Hi,

Is there a way to combine the Right function with Vlookup?

I have a statement that comes each month with lots of donors numbers
identifying their contributions. Here is an example:
501257-287640

The last six digits are unique to individual donors. I'd like to use Vlookup
to identify their contribution each month.

I need a formula that might look something like this, but this is pretty
lame and doesn't work.
=VLOOKUP(287640,RIGHT(Data!I20:P250,6),4,FALSE)

I've tried a few other combinations but to no avail. Is there anyway to
rearrange this combination to make it work? I'd prefer not to have to run a
macro to do it.

Thanks for any advice you can offer.

Harold