| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup in Multiple Workbooks
Hello
Can anyone help please? I need to look up an estimate number which is workbook number 1 and find it in work book number 2 and then find the selling price value and enter it in a blank cell in work book number 1. I thought this would work with a vlookup but I only get some correct results and then the ones it can not locate it puts in the last value that is found in workbook 2. How do I get the spreadsheet to give me only the correct answers and where the estimate number can not be found leave it blank or but n/a? The estimate numbers are combinations of letters and numbers e.g. I45236. Could this be causing the problem? -- Thanks for your advice in advance. Excel Crazy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple if or multiple vlookup | Excel Worksheet Functions | |||
| AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
| how do I use vlookup for multiple occurrences of the same value | Excel Worksheet Functions | |||
| Macro that will add data from multiple workbooks to the 1st open r | Excel Discussion (Misc queries) | |||
| Can VLOOKUP return multiple answers based on several identical lo. | Excel Worksheet Functions | |||
Threaded Mode
