DebbieFost
asked on
Excel Value Help
Please see the attachement.
1. I need a value to looks at the cells in the "Item" Column and then takes the Item#
2. Then cross references against another Column "Item"
4. Then Looks at the Corresponding "Memo" column
5. Then Copies it the First Memo Field.
Thank you,
Value-Example.docx
1. I need a value to looks at the cells in the "Item" Column and then takes the Item#
2. Then cross references against another Column "Item"
4. Then Looks at the Corresponding "Memo" column
5. Then Copies it the First Memo Field.
Thank you,
Value-Example.docx
ASKER
Here is the workbook. I need to reference the QuickbaseARChargoffExport Tab information, against the AR Cat to GL Code Converter Tab.
QuickBase-Affinity-Converters.xlsm
QuickBase-Affinity-Converters.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
=VLOOKUP(A3,Sheet2!B$1:C$1
Had you posted the actual workbook, then I could have made all the corrections for worksheet layout for you.
Brad