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? |
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? |
All times are GMT +1. The time now is 04:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com