Hey Folks! I'm new here and i might need some help. This is on google sheets!
Capture.PNG
Formula: =INDEX(HH!$C$5:$FE$10,MATCH(J$9,HH!$B$5:$B,0),MATCH($A10,HH!$C$2:$FE$2,0))
the #NUM! error happens when I drag down the equation. I want to get all the data from HH and HB but im getting this error: Function INDEX parameter 2 value 7 is out of range.
Thank you!
Attached is the excel file.
DUMMY OF OOS & LSW.xlsx
Last edited by bbbrohm; 09-21-2022 at 01:09 AM.
I dont use "sheets" that often, but it looks to me like you need to "end" the range in the 1st MATCH.....
=INDEX(HH!$C$5:$FE$10,MATCH(J$9,HH!$B$5:$B,0),MATCH($A10,HH!$C$2:$FE$2,0))
mabye =INDEX(HH!$C$5:$FE$10,MATCH(J$9,HH!$B$5:$B10,0),MATCH($A10,HH!$C$2:$FE$2,0))
in your excel sheet, normally the INDEX range spans both MATCH ranges, but yours looks all out of wack?
=
INDEX(HH!$C$4:$FE$9,
MATCH(D$9,HH!$B$4:$B270,0),
MATCH($A13,HH!$C$2:$FE$2,0))
Your INDEX (where the answer comes from) is C4:FE9
but you are getting your row and column intercept from B4:B27 and C2:FE2
The col ranges looks OK, but the ROW range looks way too long?
Last edited by FDibbins; 09-21-2022 at 12:01 AM.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you so much Sir! It's working!Originally Posted by FDibbins
Happy to help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks