Vlookup up or index match

[TZ Saic]

Please help,

I need a problem with returning right data in Sheet File for posting column C.

In sheet HRK column C is Vendor Name and column M has Transaction Type. Sheet MP contains mapping information (Column A Transaction Type, Column B Vendor Name, Column C - Vendor Account Number).

In column C of Sheet File for posting there should be Vendor Account number (criterias are columns C nad column M in sheet HRK).

If in sheet HRK cells C4 and C5 contain Laniste and cell M4=P and M5=D, then in sheet File for posting cell C4=1100000004 and cell C5=2200000052.

Attached is file.

Thank you

[cbatrody]

Hi,

Try the following array formula in "File for Posting" sheet C2:

Please Login or Register  to view this content.

Note that this is an array formula and needs to be confirmed by pressing CTRL+SHIFT+ENTER

[Glenn Kennedy]

A non-array alternative (faster if there are LOTS of rows), which also removes the possibility of ambiguous answers should two concatenation strings yield the same result (11 and 22 versus 112 and 2, which would both yield 1122)

[TZ Saic]

I prefer non-array alternative. It works great! Thank you!

[Glenn Kennedy]

Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.