V-Lookup referring to multiple sheet

MScutti

I'm trying to link cells pulled from other sheets called  {Projects Info 2018 CG1-5,10} & ,{Projects Info 2018 CG 6-9}. When the column called "project" in my sheet is the same as in {Projects Info 2018 CG1-5,10} & ,{Projects Info 2018 CG 6-9}, then return result from column 14.

When using the following Vlookup formula in a cell it works but only refers to one sheet.

=VLOOKUP([PT Project #]11, {Projects Info 2018 CG1-5,10}, 14, false)

When I try to insert both sheets in the formula, as follow...

=VLOOKUP([PT Project #]11, {Projects Info 2018 CG1-5,10}{Projects Info 2018 CG 6-9, 14, false)

I get the following error message: #UNPARSEABLE

Both sheets are identical in format. How to I refer to both and get a result?

Thank you.

BP97

see the following page

https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets

under "Limitations and Important Notes" it says:

"When you create a reference to another sheet, you can only reference data from a single sheet. If you need to reference data from multiple sheets, you’ll need to create multiple references using the steps below."