How to Lookup Candidate Status Based on Two Criteria

[dougers1]

Hi

i need some help, i have a task at work that i am required to pull over the candidate status over to a new sheet, i was originally using a vlookup function on the email address and pulling over the status. i now have a issue where the candadate can now apply for more than one job reference

so when i use vlook up it only pulls over the 1st status for that candadate - how do i get is so it checks for the job ref and email and then pull over the status



TY
D

[AliGW]

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[dougers1]

Hi Ali

im unsure what the title should be , i have edited it just now , is that ok

[AliGW]

No - sorry. It doesn't tell us what you are trying to do. It is still generic. Use this: "How to Lookup Candidate Status Based on Two Criteria".

No help to be offered until this change has been made.

Are you still using Excel 2010?

[AliGW]

That's better - thanks.

Are you still using Excel 2010? If so:

=INDEX($H$2:$H$5,MATCH(1,($A$2:$A$5=C9)*($D$2:$D$5=D9),0))

**Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).

AliGW on MS365 Beta Channel (Windows 11) 64 bit

	C	D	E
9	65931	Donal Duck @gmail.com	Hired - employee starts

Sheet: Sheet1

[dougers1]

Hi

thats it changed and yes still 2010 due to employment - sorry

[AliGW]

See post #5.

[dougers1]

thanks i will have a look and close post

[AliGW]

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.