vlookup function between 2 workbook & logic

		Microsoft Office Forums > Microsoft Excel > Excel
vlookup function between 2 workbook & logic

07-05-2023, 07:14 PM

stricky

Windows 10 vlookup function between 2 workbook & logic

Office 2019

Novice

Join Date: Jun 2023

Location: Bangladesh

Posts: 25

i have to change M/C name manualy for every M/C for each sheet (158 times). there are 30 sheets. i have solved this by changing "M/C name" to cell #.

Quote:

=SUMIFS('[01-02-23-BB.xlsx]DELEV-B'!$O$9:$O$568,'[01-02-23-BB.xlsx]DELEV-B'!$C$9:$C$568,C7)

but i have to 1st open data files and work? there are 58-62 files originally in there. how do i work around that?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel VBA Vlookup function help	Mark.Christian	Excel Programming	1	07-19-2016 11:32 AM
VLOOKUP is dependent up IF function	dmccrar	Excel	2	09-14-2014 09:51 AM
Using If and Vlookup Function	jassi.mgg@gmail.com	Excel	5	03-16-2014 01:47 AM
Using vlookup with the IF function	CSzoke	Excel	11	06-01-2013 10:56 PM
Is this possible using the Vlookup or any other function?	Delson	Excel	4	02-08-2010 01:27 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:37 PM.