I have two spreadsheets first spreadsheet "A" has a common value ie: 43850431000 in column "H" as in spreadsheet "B". I want to search the entire spreadsheet "B" and if value "H" is found retrieve the invoice number in column "F" for all that match. How would I do this?
Further, I want to retrieve the quantities and dollar amounts associated with the invoice. These would be sheet "B" columns "J" and "L".
Thank you in advance for your help!!!
Bookmarks