Help with a formula to match two criteria

[yamaijia]

Two tables, Daily Entry and Wage Change.

I need a formula that can find the wage during the date of entry on the "Daily Entry" table from the "Wage Change" table. Formula would be inputted from C3 to C17. Im sorry if im unclear, let me know what i need to clarify.

Basically im trying to input employee daily job without having to input their salary every time, but it needs to reflect their salary at that as well.

Thanks.E.g..png

[FDibbins]

Hi, welcome to the forum

Maybe this>
=index(I:I,match(a3&b3,index($G$3:$G$9&$h$3:$h$9,0),0))

[bebo021999]

Try in C3 then drag down:

=LOOKUP(B3,1/($G$3:$G$9=A3)*$H$3:$H$9,$I$3:$I$9)

[yamaijia]

the index gave me a 0 on the search, whether its ENTER or ENTER+CTRL+SHIFT

This seemed to do the trick
=LOOKUP(B3,1/($G$3:$G$9=A3)*$H$3:$H$9,$I$3:$I$9)

Thanks bebo and Fdibbins

I'll update if there is any error. THanks for the insanely quick reply!!!!

[FDibbins]

Can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

[bebo021999]

Can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

I think he has found what he need and he is giving a test.
BTW, your INDEX should work if INDEX range is same dimension with MATCH range, AND using approx. MATCH

[FDibbins]

BTW, your INDEX should work if INDEX range is same dimension with MATCH range, AND using approx. MATCH

Didnt think that would matter, but then maybe...
=index($I$3:$I$9,match(a3&b3,index($G$3:$G$9&$h$3:$h$9,0),0))

Would still like to see a sample file to test with

[yamaijia]

Try in C3 then drag down:

=LOOKUP(B3,1/($G$3:$G$9=A3)*$H$3:$H$9,$I$3:$I$9)

I applied your formula to the main file, it worked, but it takes a long time to process as the number of data that is on it.

[bebo021999]

I applied your formula to the main file, it worked, but it takes a long time to process as the number of data that is on it.

Maybe to combine name&date in a helper column then do the VLOOKUP.

[yamaijia]

Maybe to combine name&date in a helper column then do the VLOOKUP.

How would it be able to search the salary correctly?