Hi guys/girls,
I have been given a formula that works great to a point.
It accesses a column, and looks up two values in that column (values are referenced in F2 and F3). It then returns the adjacent value in either column A or column B (depending on the formula) for each found instance.
My problem is that if I delete one of the ref cells (F3 or F2) it returns crazy numbers.
I would like it to look for both OR one OR the other OR nothing if there is none.
Any help including thoughts would be great at this stage as deadlines are looming and then clouds will be shrooming!
Thank you in advance for any help.
FolloWing is the code and a stripped down sheet with values and formulae needed
PS. Formula is a ctrl+shift+enter array formula..
Please Login or Register to view this content.
353354d1413915941-index-array-formula-using-multiple-criteria-and-indirect-references-can-it-wo.xlsx
Bookmarks