2 way Vlookup - Creating array arguments as needed

"Hari" <excel_hari@yahoo.com> wrote in message
news:1147351100.594324.227040@g10g2000cwb.googlegroups.com...
> Bob,
>
> Thanks a TON for the solution.
>
> It works really well. I just added the column agument 1 for index
> function (=INDEX(D1:D4,MATCH(1,((A1:A4=F1)*(B1:B4=G1)),0),1))

That shouldn't be necessary. Did you have a problem without it?

Bob,

Thanks. Nice stuff to learn for the day. I never noticed that the
column argument for Index is optional (when row number is already
menioned and viceversa).

regards,
HP
India