Hi all!
<tbody>
</tbody>
Order number 4568 has ordered 2 items, so on my invoice I need to find the second item that 4568 has. I can use vlookup for the first item obviously, but not sure how to return "fork" and "big" on my invoice. I anticipate many blanks in column 1.
Thanks!!
EDIT: I should add, the invoice is on a second spreadsheet and I plan to have do a vlookup from the second spreadsheet.
order number | item | description |
4567 | pots | grey |
4568 | spoon | dessert |
fork | big | |
4569 | pans | stainless |
<tbody>
</tbody>
Order number 4568 has ordered 2 items, so on my invoice I need to find the second item that 4568 has. I can use vlookup for the first item obviously, but not sure how to return "fork" and "big" on my invoice. I anticipate many blanks in column 1.
Thanks!!
EDIT: I should add, the invoice is on a second spreadsheet and I plan to have do a vlookup from the second spreadsheet.
Last edited by a moderator: