Hello, I am looking for a formula to look up a value. Here is my criteria:
**2 different columns of data in worksheet B and should match two different cells on a worksheet A. I need to input the cell from worksheet from worksheet B into a cell in worksheet A.
Example of the criteria:
** Column D on worksheet B will reference Cell C on worksheet A
** Column E on worksheet B will reference Cell F on worksheet A
** Then with this criteria, Colmun G in worksheet B will be used to pull the number/name of the info in the cell meeting that criteria. The info will go into Cell H in worksheet A.
Can anyone help? I've tried different Matches, vlookups, and indexes, but not much luck so far.
Also if there is a blank in Column G, I need it to not input any data.
Appreciate any of your help
**2 different columns of data in worksheet B and should match two different cells on a worksheet A. I need to input the cell from worksheet from worksheet B into a cell in worksheet A.
Example of the criteria:
** Column D on worksheet B will reference Cell C on worksheet A
** Column E on worksheet B will reference Cell F on worksheet A
** Then with this criteria, Colmun G in worksheet B will be used to pull the number/name of the info in the cell meeting that criteria. The info will go into Cell H in worksheet A.
Can anyone help? I've tried different Matches, vlookups, and indexes, but not much luck so far.
Also if there is a blank in Column G, I need it to not input any data.
Appreciate any of your help
