In fact you don't need the red part of the formula.
=+INDEX(INDEX('Pay lookup table'!$B$2:$F$101,0,MATCH($G$2,'Pay lookup table'!$B$1:$F$1,0)),MATCH(G40,'Pay lookup table'!$A$2:$A$101,0))
You can use the formula in this way.
=INDEX('Pay lookup table'!$B$2:$F$101,MATCH(G40,'Pay lookup table'!$A$2:$A$101,0),MATCH(G2,'Pay lookup table'!$B$1:$F$1,0))
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Or
=IFERROR(VLOOKUP(G40,'Pay lookup table'!$A$2:$F$101,MATCH(G2,'Pay lookup table'!$A$1:$F$1,0)),"")
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
fizzwolf 
Register To Reply
Bookmarks