# Combine INDEX+MATCH functions with INDIRECT formula

1. ## Combine INDEX+MATCH functions with INDIRECT formula

Hi,

I need some heads up on how to combine some formulas. Here is my formula:

=INDEX(A5:T100,ROW(5:5),MATCH(L4,A4:T4,0))

Arrays are in 3 separate sheets (similar layout). Cell L3 would represent sheet name. So, whatever sheet name is in L3, formula is working with that sheet.

3. ## Re: Combine INDEX+MATCH functions with INDIRECT formula

All arrays in those sheets. Formula should begin like this:

=INDEX(INDIRECT("'"!&L3&A5:T100"),ROW(INDIRECT(..........

4. ## Re: Combine INDEX+MATCH functions with INDIRECT formula

Would it be:

=INDEX(INDIRECT("'"&l3&"'!A5:T100"),ROW(5:5),MATCH(L4,INDIRECT("'"&L3&"'!A4:T4"),0))

5. ## Re: Combine INDEX+MATCH functions with INDIRECT formula

Great! Thanks, I've got it working.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1