Excel Value Help

DebbieFost used Ask the Experts™
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,
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
byundtMechanical Engineer
Most Valuable Expert 2013
Top Expert 2013

You are looking for a VLOOKUP formula. Let’s assume that the table with AR category/Item/Memo is in Sheet2 cells A1:C100. If the Item in step 1 is in cell A3, then you can get the value for step 4 Memo field as:

Had you posted the actual workbook, then I could have made all the corrections for worksheet layout for you.



Here is the workbook.  I need to reference the QuickbaseARChargoffExport Tab information, against the AR Cat to GL Code Converter Tab.
Mechanical Engineer
Most Valuable Expert 2013
Top Expert 2013
Given the named ranges already in your workbook, worksheet QuickbaseARChargoffExport cell F2 can use:

You could also use a VLOOKUP like:
=VLOOKUP(E2,'AR Cat to GL Code Converter'!$B$2:$D$19,2,FALSE)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial