Index match from grouped tabs

TonyMcCann

New Member
Joined
Nov 17, 2005
Messages
2
Hi,
I am trying to record a basic macro incorporating index match for a group of tabs.

Each tab is for a separate product and the layout for each tab is identical. The cell E2 is the identifier cell. In cell E20 I am trying to pull info from cell F21 from a file updated on a weekly basis known as "last weeks plinks", and continuing the formula across to N21. This is to update with historical data on a week by week basis. Ihave copied and pasted cells to be pulled as values to prevent errors pulling formulae.

I have used the following formula -

=index('[lastweeksplinks.xls]productA:productZ'!F21,match('ProductA:ProductZ'1$E$2,'[lastweeksplinks.xls]ProductA:ProductZ'!$E$2,0))

This reults in "#value! rather the info appearing.

Can anyone help?

Many thanks
Tony
 

Some videos you may like

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Watch MrExcel Video

Forum statistics

Threads
1,118,823
Messages
5,574,523
Members
412,601
Latest member
TheBeaniacExpress
Top