I'm working with two Google Spreadsheets and trying to have a cell in the first sheet populate data after inputting a number in cell E06 and have this number match three criteria on the second sheet in a specific order:
1. Have number in E06 on 1st spreadsheet match one of the values in column B of 2nd sheet.
2. Have the cell in column C that is on the same row to be compared to the entry on column A within the same row (there are repetitive numbers in column B, but each are paired with different words)
3. Have the value in column A in 2nd spreadsheet imported into cell E18 of the 1st spreadsheet.
I apologize if this is confusing - please let me know if I can clarify!
1. Have number in E06 on 1st spreadsheet match one of the values in column B of 2nd sheet.
2. Have the cell in column C that is on the same row to be compared to the entry on column A within the same row (there are repetitive numbers in column B, but each are paired with different words)
3. Have the value in column A in 2nd spreadsheet imported into cell E18 of the 1st spreadsheet.
I apologize if this is confusing - please let me know if I can clarify!
