New to INDEX MATCH

[Lmacdonald198]

I need to find out if a specific code appears on a separate worksheet ([Ex_SG_001_consolidated Employer data - version 1 - 06-06-2017.xlsx]Post 05 Liquidations'!$A$3) and if it does I want it to return the data that's in cell K6 that I'm currently working on. If its not on the Employer data spreadsheet then it needs to return a BLANK.

 

[JackDanIce]

Welcome to the board.

I think you're trying to create a "reverse" VLOOKUP, but it's not clear what column of data you are matching the specific code against and what column of data you want to return an adjacent value from.

See if this example helps you: https://www.deskbright.com/excel/using-index-match/