LinkBack URL
About LinkBacks
Hi I wonder if anybody can help with this I'm trying to get the correct price from the table from the data entered in AB2 and AB3. The function used is in cell AB7.
Any help would be greatly appreciated.
Book1.xlsx
Hi I wonder if anybody can help with this I'm trying to get the correct price from the table from the data entered in AB2 and AB3. The function used is in cell AB7.
Any help would be greatly appreciated.
Book1.xlsx
You cant do Match on @d range - it has to be either one column or one row.
Use for instance such array formula*
Formula:
Please Login or Register to view this content.
*...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
Best Regards,
Kaper
OR,
try the following formula in AB7:
=INDEX(A1:Z4,IF(ISNA(MATCH(AB2,B2:P2,0)),IF(ISNA(MATCH(AB2,B3:P3,0)),IF(ISNA(MATCH(AB2,B4:P4,0)),0,4),3),2),MATCH(AB3,A1:Z1,0))
I don't think I should be this happy about Excel. Thank you chaps.....
I've added to the table, expanded on the function and broken it. If somebody could help point out where I've gone wrong I would appreciate it.
Book1.xlsx
Hi,
I have updated the formula in the attached file.
Thank you again. What's the reason for this part at the end of the function? )),0,10),9),8),7),6),5),4),3),2),
That decides the matching row!
Enter this formula in B17 as an ARRAY formula:
Formula:Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Kaper's formula works fine if you change the references to match your new file.
Formula:Please Login or Register to view this content.
And just a reminder: don't forget it is array formula - committed with CTRL+SHIFT+ENTER
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks