| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Look up duplicate amounts with unique batch numbers
Hi,
The Lookup value has to be from a list of unique data. When your lookup value is 5.49, which batch number do you actually want returned? Also, something I didn't understand from your original post, You said you had 2 lists in separate spreadsheets, but your data is arranged in 3 lists (Amount, Batch Number, Amount 1) Regards - Dave. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filtering Duplicate Data to obtain Unique record | Excel Worksheet Functions | |||
| Duplicate and unique items in 2 lists | Excel Discussion (Misc queries) | |||
| how to get word amounts from numbers in cels | Excel Discussion (Misc queries) | |||
| Unique and duplicate data between 2 Excel worksheets | Excel Worksheet Functions | |||
| In column A I have duplicate records. How do I tag an unique reco. | Excel Discussion (Misc queries) | |||
Hybrid Mode
