Pull field from one worksheet if match from two cells from another worksheet match two cel

[noraroe]

I have two worksheets. One contains a client name in one column and project name in another column. I need to match both client name and project name on the second worksheet and if a match, then pull in data from a different cell on the match row. This is my current formula but it is not quite working. My list contains 2540 rows to search through for a match.

=IF(AND(EXACT($D2,'WStwo'!$B$2:$B$2540),EXACT($E2,'WStwo'!$C$2:$C$2540)),'WStwo'!$D$2:$D$2540)


Name in Column D and Column E on WSone must match the name exactly in both Column B and Column C on WStwo. Once if finds a match, then I need the data in Column D on WStwo. Once I can get this formula to work, then I will be doing the same to pull in data from other columns on WStwo into WSone as well.

I would think this requires a VLOOKUP formula since I need to search and entire row on another sheet. So a formula within a formula within a formula? Above my pay grade, but I know Excel can do it.

Thanks for any help I can get on this.

[Melvosh]

Your best bet is to use INDEX / MATCH. I hope I have your cell references correct. This formula needs to be entered as an array formula using ctrl+shift+enter:

Please Login or Register  to view this content.

Does that give you the results you're expecting?