Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,520
Default Index, match, multiple IFs query

Please let us know the cell range of ONE TWO ...etc; refers to..and if
possible elaborate a bit more about how your data is arranged

--
Jacob (MVP - Excel)


"zx6roo" wrote:

I have the following individual functions
=INDEX(Sheet2!$D$3:$H$7,MATCH($F7,ONE,0),5)
=INDEX(Sheet2!$D$3:$H$7,MATCH($F7,TWO,0),5)
=INDEX(Sheet2!$D$3:$H$7,MATCH($F7,THREE,0),5)
=INDEX(Sheet2!$D$3:$H$7,MATCH($F7,FOUR,0),5)
=INDEX(Sheet2!$D$3:$H$7,MATCH($F7,FIVE,0),5)


I need to combine them all in the same cell so IF F7 matches data in ranges
ONE, TWO, ETC it will return whatever is in column 5.

Ive done some searching on the net and also looked at Microsofts help on
this. I can see how to create a multiple function if I want it to be ONE &
TWO but not ONE or TWO. Ive tried various combinations of functions but a
little stuck.

Any help is much appreciated.

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default Index, match, multiple IFs query

The data on sheet two is arranged in as a table.
Range ONE is B4 to B8
Range TWO is C4 to C8
And so on.

F7 can be anything in any of those ranges. What I want is for a lookup to
see what is in F7, look at the table, find whic range it is in and then give
me the number that is located in column 5 of that range.

"Jacob Skaria" wrote:

Please let us know the cell range of ONE TWO ...etc; refers to..and if
possible elaborate a bit more about how your data is arranged

--
Jacob (MVP - Excel)


"zx6roo" wrote:

I have the following individual functions
=INDEX(Sheet2!$D$3:$H$7,MATCH($F7,ONE,0),5)
=INDEX(Sheet2!$D$3:$H$7,MATCH($F7,TWO,0),5)
=INDEX(Sheet2!$D$3:$H$7,MATCH($F7,THREE,0),5)
=INDEX(Sheet2!$D$3:$H$7,MATCH($F7,FOUR,0),5)
=INDEX(Sheet2!$D$3:$H$7,MATCH($F7,FIVE,0),5)


I need to combine them all in the same cell so IF F7 matches data in ranges
ONE, TWO, ETC it will return whatever is in column 5.

Ive done some searching on the net and also looked at Microsofts help on
this. I can see how to create a multiple function if I want it to be ONE &
TWO but not ONE or TWO. Ive tried various combinations of functions but a
little stuck.

Any help is much appreciated.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Index & Match functions - multiple criteria and multiple results [email protected] Excel Worksheet Functions 4 May 2nd 07 03:13 AM
SUMPRODUCT or INDEX/MATCH for multiple conditions and multiple rec TravisB Excel Discussion (Misc queries) 21 March 16th 07 09:49 PM
if, Isnumber, Match, &index query Juls Excel Discussion (Misc queries) 0 October 23rd 06 02:07 AM
index and match query kate Excel Worksheet Functions 1 August 7th 06 12:59 AM
INDEX AND MATCH QUERY ? kate Excel Worksheet Functions 2 July 17th 06 01:19 PM


All times are GMT +1. The time now is 08:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"