PDA

View Full Version : [SOLVED] Match Funtion Help



Nick72310
02-26-2016, 09:59 AM
15481

I have attached the document that I am having issues with. I have some simple VBA code for sheet1, which works fine. The issue is in cells B11 and B12 on sheet1. They are not matching the correct row that I want. I cannot understand why it is not working. I do have a few named ranges in the document, which I also use in my VBA code and formulas in sheet 1.
Thanks for the help!

Paul_Hossler
02-26-2016, 10:18 AM
Add the ,0 inside the MATCH ()'s and see if it works




=MATCH(1,($A$8=ITEM_NUM)*("Make"=MAKE_BUY),0)+1

Nick72310
02-26-2016, 10:22 AM
Hahaha I feel so dumb.
That fixed my problem! Thank you for the quick reply.