Posted to microsoft.public.excel.worksheet.functions

helpme

Posts: n/a

Index and Match

A1
=INDEX($C$130:$G$148,MATCH(B$82,$B$130:$B$148,0),M ATCH(I$55,$C$129:$G$129,0))

This works perfectly if cell B82 is a number (eg. 69.9%) and I55 is a
formula. However, I need cell B82 to be a formula. If I change B82 to any
formula then cell A1 shows N/A. The result of the formula in B82 shows a
result that is valid in my table. Why do I get N/A in cell A1?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Match Index	cjjoo	Excel Worksheet Functions	3	October 25th 05 09:33 AM
Match or Index Question	carl	Excel Worksheet Functions	2	October 4th 05 09:11 PM
Match & Index	Phyllis B.	Excel Worksheet Functions	2	November 27th 04 03:26 PM
Find a match that;s not exact	Phyllis	Excel Worksheet Functions	0	November 8th 04 08:12 PM
Vlookup, Index & Match	Phyllis	Excel Worksheet Functions	1	November 8th 04 06:11 PM

All times are GMT +1. The time now is 01:16 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us