Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup?
I have 2 spreadsheets
The first is a large table with thousands of invoice numbers in no particular order that have been billed. Weekly I get a second spreadsheet with a set of 50 or so invoice numbers that appear somewhere on the first sheet (no particular order). These are invoices that have been paid that week. This sheet also shows the date paid. I need a formula to match the invoice numbers from the paid sheet to the billed sheet and return the date paid in another column on that billed sheet |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matrix lookup/mulitple criteria lookup | Excel Discussion (Misc queries) | |||
Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) |