Index Match a range

[Russk68]

Hi All

I want to index a column and match a criteria in multiple columns.

I want to index column A and find a match in columns B:F
I gave this a try =INDEX(A1:A20,MATCH(G1,B1:F20,0))

Thanks!

 

[Zack Barresse]

I'm sorry, it's incredibly difficult to understand your data, especially without proper explanation. I see the job range in B31:B100. Am I understanding you correctly when you say you want to match a single value (G1) across multiple columns? If that's the case, I strongly recommend you look up data normalization, as your data shouldn't be columnar or unpivoted. Instead, keep each field in its own column. Input data separate from output data, don't mix the two.

 

[Russk68]

Got it!

https://www.dropbox.com/s/hkbc84zwjlx39r2/CrewCal.2.xlsx?dl=0

The 2 sheets that I am working on are Assign and Grid.

Any help is always greatly appreciated!