Formula whit INDEX and MATCH. I try to make this formula to result.

**Anka** · 10-28-2012, 02:32 PM

Hi all !

I have a workbook with four sheets. The first sheet is a general view of the other three sheets (some calculations). I try to put the exact results sheets which they belong.
I adapted a formula that works perfectly on the first sheet but does not result in the other.
To be honest I do not know how I did it, but can not make it work for the other sheets.

Thanks in advance for your help.

PS: Accept any other suggestions.
May be VBA code to automate it.

My English is horrible. Sorry!

**AlphaFrog** · 10-28-2012, 03:45 PM

Put these two formulas on each sheet and drag them down their column.

M9

Formula:

Please Login or Register  to view this content.

N9

Formula:

Please Login or Register  to view this content.

**Anka** · 10-28-2012, 04:09 PM

Yeap. That's it. Works. I was close.

Thanks a lot buddy.

**AlphaFrog** · 10-28-2012, 04:20 PM

You're welcome.

Because you have Excel 2010, you could use these slightly shorter formulas.

M9

Formula:

Please Login or Register  to view this content.

N9

Formula:

Please Login or Register  to view this content.

**Anka** · 10-28-2012, 06:26 PM

Thanks a lot, again.

Formula whit INDEX and MATCH. I try to make this formula to result.

LinkBack

Thread Tools

Rate This Thread

Display

Formula whit INDEX and MATCH. I try to make this formula to result.

Re: Formula whit INDEX and MATCH. I try to make this formula to result.

Re: Formula whit INDEX and MATCH. I try to make this formula to result.

Re: Formula whit INDEX and MATCH. I try to make this formula to result.

Re: Formula whit INDEX and MATCH. I try to make this formula to result.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions