Forum Discussion
Excel formula query
=IFERROR(VLOOKUP(C2,$G$2:$H$14,2,FALSE),"")
I changed the formula for column E (Partner ID) as shown above. This works in my sheet. Unfortunately i didn't understand in the beginning what you want to do.
This formula changes the values in columns L and M as well. Are the results in columns L and M what you finally want to do?
Is this what you want to do?
OliverScheurich Thanks for your help.
Thanks for your quick response on this query.
I can see that the ID number in column B is matchimg with Column J and pulling the invoice value into column F which is what it should do.
The only thing that appears not to be quite right is that the channel partner name in colum C should have the partner ID in Column E that is returned from the list in column H which for that particular channel partner.
Therefore the formula needs to take the data in C2, "Mai Baker" and seasrch for the correseponding name in Column G and return the correspopnding partner abbrev in Colimn H to the partner ID Column
The above examples show that "Mai Baker" in C2 should have a Partner id of AA in Column E however it is showing BB.
=IFERROR(VLOOKUP(C2,$G$2:$H$14,2,FALSE),"")
I changed the formula for column E (Partner ID) as shown above. This works in my sheet. Unfortunately i didn't understand in the beginning what you want to do.
This formula changes the values in columns L and M as well. Are the results in columns L and M what you finally want to do?
- Thanks for your help, formula is working well.
Cheers
robwill100 Try the attached file.
