CODEWITHSUNDEEP
excelexcel-formulamatch
Shivanand T
Shivanand T

Reputation: 1283

Match function of Excel with different sheets

I want to use match function but the lookup array is in a different sheet.

Here is what I am trying:

= MATCH( "Lead-POI-BBA Concours", SHEET_13_15!F5 : SHEET_13_15!O5)

but it is giving an error 

#N/A

I tried changing it to 

= MATCH( "Lead-POI-BBA Concours", 'SHEET_13_15'!F5 : 'SHEET_13_15'!O5)

But it again reverts back to 

= MATCH( "Lead-POI-BBA Concours", SHEET_13_15!F5 : SHEET_13_15!O5)

giving the same error

#N/A

Where am I making a mistake

Upvotes: 0

Views: 286

Answers (1)

cyboashu
cyboashu

Reputation: 10433

No Need to refer the sheet twice. Its Sheet!Range

= MATCH( "Lead-POI-BBA Concours", SHEET_13_15!F5:O5)

Upvotes: 2

Related Questions