| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP to pick information from two worksheets
Having problems with using VLOOKUP when trying to use a range from two
worksheets, how is this done? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP to pick information from two worksheets
I assume that you mean there are two possible data ranges, only one of which
will have the look-up data in it. =if(iserror(vlookup(lookup-value,Sheet1!range1,col,False)),vlookup(lookup-value,Sheet2!range2,col,False),vlookup(lookup-value,Sheet1!range1,col,False)) "mikeclimb" wrote: Having problems with using VLOOKUP when trying to use a range from two worksheets, how is this done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking worksheets using a master document | Excel Discussion (Misc queries) | |||
| Vlookup question | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| vlookup worksheet(s) | Excel Discussion (Misc queries) | |||
| Charting information from a number of worksheets | Charts and Charting in Excel | |||
Linear Mode
