I have two sheets with related, but different, information. What I would like to do is to first check if cell value B2 in Workbook 1 is greater than zero (easy enough). If it is, then I want to lookup and display all rows in Workbook 2 whose index value in A2 match that of Workbook 1 cell A2. Then, proceed to check the rest of the sheet...B3, B4, B5, etc...and display the resulting data for each of those as well.
Does that make sense?
I have attached a generic example workbook to better describe what I need. Please note that although "Workbook1" and "Workbook2" are on different sheets, in reality they are totally separate workbooks.
I assume this will have to be done in VBA, as standard Excel functions (such as vlookup) will only return the first row of data it finds. However, if you know something I don't, and this CAN be done with standard Excel functions, please let me know.
Thanks in advance for your assistance!