searching across multiple worksheets for a single value in E

P

PhilipLawrence99

New Member
Joined
Aug 11, 2002
Messages
20
Hi there, does anyone know how to do an exact search (vlookup style) across multiple worksheets in Excel? The worksheets would all be in the same file by the way.

Cheers,
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

D
  • Question
Generate worksheet name based on cell lookup across multiple worksheets
Replies
1
Views
112
Darren_workforce
D
C
  • Question
Copy and paste data through multiple workbooks
Replies
2
Views
203
CDaviess
C
tabbytomo
  • Solved
Copy entire row if cell has specific value, looking at multiple columns and worksheets.
Replies
2
Views
298
NateSC
NateSC
B
  • Question
VBA to copy multiple worksheets to new workbook
Replies
1
Views
234
bradsalmon
B
jl2509
  • Solved
Lookup a value in a sheet and return the left column value
Replies
3
Views
144
Fluff
Fluff

Forum statistics

Threads
1,215,032
Messages
6,122,772
Members
449,095
Latest member
m_smith_solihull

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top