george hart
Board Regular
- Joined
- Dec 4, 2008
- Messages
- 241
Hi can anyone help
I need the vlookup below to look at various speradsheets. For example, replcae Operations KPI - Mike Keeber.xls with Operations KPI*.xls
=VLOOKUP(B85,'[Operations KPI - Mike Keeber.xls]Actual Operations KPI'!$B$85:$O$95,2,FALSE)
Can you use a wildcard in a vlookup?
Many thanks
I need the vlookup below to look at various speradsheets. For example, replcae Operations KPI - Mike Keeber.xls with Operations KPI*.xls
=VLOOKUP(B85,'[Operations KPI - Mike Keeber.xls]Actual Operations KPI'!$B$85:$O$95,2,FALSE)
Can you use a wildcard in a vlookup?
Many thanks
