INDIRECT, can I use it in these formulas?

[itsrich]

This formula is repeated 26 times the only thing changing is the TAB reference.

=IF(ISERROR(VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]KOV185PROWT'!$A:$F,6,FALSE)),"",VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]KOV185PROWT'!$A:$F,6,FALSE))

Am I up against, INDIRECT does not work When referencing another workbook?

If I can use INDIRECT, it means typing the formula once. If I cannot use it, then it is a bunch of copy/paste for me.

Is this formula written correctly? =VLOOKUP(B3,INDIRECT("'[2022 FishBOM - RIVETED v 02.xlsx]""&G1&""!$A:$F"),6,FALSE)

2022.05.22 Location Study - Riveted.xlsx
	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF
2	KOV185PROWT	KOV198PROWT	KOV200PROWT	FRV165SC	FRV165WT	FRV189WT-JUMP	FRV189WT	FRV179SC-20	FRV179SCJ-20	FRV179WT-20	FRV179WTJ-20	FRV179WT-25	FRV179WTJ-25	OLV2010WT (CATFISH)	OLV2010CC 20 & 25	OLV2010SC 20 & 25	OLV2010WT 20 & 25	OLV2010T 20 & 25	OLV186CC	OLV186SC	OLV186T	OLV165T	OLV165SC	OLV156T	OLV156SC	OLV146T
3																				M-FINAL
4	M-SUB	M-SUB	M-SUB	M-SUB	M-ASSY	M-SUB	M-SUB	M-SUB	RVT	M-SUB	M-SUB	M-SUB	M-SUB	M-ASSY	M-SUB	RVT	M-SUB	M-SUB				M-SUB	M-SUB	M-FINAL	M-SUB
Sheet2

Cell Formulas
Range	Formula
G3	G3	=IF(ISERROR(VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]KOV185PROWT'!$A:$F,6,FALSE)),"",VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]KOV185PROWT'!$A:$F,6,FALSE))
H3	H3	=IF(ISERROR(VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]KOV198PROWT'!$A:$F,6,FALSE)),"",VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]KOV200PROWT'!$A:$F,6,FALSE))
I3	I3	=IF(ISERROR(VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]KOV200PROWT'!$A:$F,6,FALSE)),"",VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]KOV200PROWT'!$A:$F,6,FALSE))
J3	J3	=IF(ISERROR(VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]FRV165SC'!$A:$F,6,FALSE)),"",VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]FRV165SC'!$A:$F,6,FALSE))
K3	K3	=IF(ISERROR(VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]FRV165WT'!$A:$F,6,FALSE)),"",VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]FRV165WT'!$A:$F,6,FALSE))
L3	L3	=IF(ISERROR(VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]FRV189WT-JUMP'!$A:$F,6,FALSE)),"",VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]FRV189WT-JUMP'!$A:$F,6,FALSE))
M3	M3	=IF(ISERROR(VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]FRV189WT'!$A:$F,6,FALSE)),"",VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]FRV189WT'!$A:$F,6,FALSE))
N3	N3	=IF(ISERROR(VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]FRV179SC-20'!$A:$F,6,FALSE)),"",VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]FRV179SC-20'!$A:$F,6,FALSE))
O3	O3	=IF(ISERROR(VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]FRV179SCJ-20'!$A:$F,6,FALSE)),"",VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]FRV179SCJ-20'!$A:$F,6,FALSE))
P3	P3	=IF(ISERROR(VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]FRV179WT-20'!$A:$F,6,FALSE)),"",VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]FRV179WT-20'!$A:$F,6,FALSE))
Q3	Q3	=IF(ISERROR(VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]FRV179WTJ-20'!$A:$F,6,FALSE)),"",VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]FRV179WTJ-20'!$A:$F,6,FALSE))
R3	R3	=IF(ISERROR(VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]FRV179WT-25'!$A:$F,6,FALSE)),"",VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]FRV179WT-25'!$A:$F,6,FALSE))
S3	S3	=IF(ISERROR(VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]FRV179WTJ-25'!$A:$F,6,FALSE)),"",VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]FRV179WTJ-25'!$A:$F,6,FALSE))
T3	T3	=IF(ISERROR(VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]OLV2010WT (CATFISH)'!$A:$F,6,FALSE)),"",VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]OLV2010WT (CATFISH)'!$A:$F,6,FALSE))
U3	U3	=IF(ISERROR(VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]OLV2010CC 20 & 25'!$A:$F,6,FALSE)),"",VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]OLV2010CC 20 & 25'!$A:$F,6,FALSE))
V3	V3	=IF(ISERROR(VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]OLV2010SC 20 & 25'!$A:$F,6,FALSE)),"",VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]OLV2010SC 20 & 25'!$A:$F,6,FALSE))
W3	W3	=IF(ISERROR(VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]OLV2010WT 20 & 25'!$A:$F,6,FALSE)),"",VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]OLV2010WT 20 & 25'!$A:$F,6,FALSE))
X3	X3	=IF(ISERROR(VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]OLV2010T 20 & 25'!$A:$F,6,FALSE)),"",VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]OLV2010T 20 & 25'!$A:$F,6,FALSE))
Y3	Y3	=IF(ISERROR(VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]OLV186CC'!$A:$F,6,FALSE)),"",VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]OLV186CC'!$A:$F,6,FALSE))
Z3	Z3	=IF(ISERROR(VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]OLV186SC'!$A:$F,6,FALSE)),"",VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]OLV186SC'!$A:$F,6,FALSE))
AA3	AA3	=IF(ISERROR(VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]OLV186T'!$A:$F,6,FALSE)),"",VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]OLV186T'!$A:$F,6,FALSE))
AB3	AB3	=IF(ISERROR(VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]OLV165T'!$A:$F,6,FALSE)),"",VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]OLV165T'!$A:$F,6,FALSE))
AC3	AC3	=IF(ISERROR(VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]OLV165SC'!$A:$F,6,FALSE)),"",VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]OLV165SC'!$A:$F,6,FALSE))
AD3	AD3	=IF(ISERROR(VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]OLV156T'!$A:$F,6,FALSE)),"",VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]OLV156T'!$A:$F,6,FALSE))
AE3	AE3	=IF(ISERROR(VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]OLV156SC'!$A:$F,6,FALSE)),"",VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]OLV156SC'!$A:$F,6,FALSE))
AF3	AF3	=IF(ISERROR(VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]OLV146T'!$A:$F,6,FALSE)),"",VLOOKUP(B3,'[2022 FishBOM - RIVETED v 02.xlsx]OLV146T'!$A:$F,6,FALSE))

 

[Fluff]

It should be

=VLOOKUP(B3,INDIRECT("'[2022 FishBOM - RIVETED v 02.xlsx]"&G1&"'!$A:$F"),6,FALSE)

Although it will only work if the other workbook is open.

 

[itsrich]

TY for confirming I did understand how INDIRECT works!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Peggi]

Hello - First time posting here.
I can't remember the exact INDIRECT formula I need to complete my task.
I have many tabs in 1 workbook, all tabs are formatted the same.
In a previous job, I created a summary tab that used a set reference line for the formulas and when I typed in the project number in the A column, all the other columns would populate with the information from that specific tab.
Here is what the individual tab looks like:

And here is the summary page I am trying to create:

The light green REF LINE is the cell reference for that specific bit of information.
Please help.

 

[Fluff]

As this is a totally different question from the OP, you need to start a thread of your own.
Thanks