![]() |
#1
|
|||
|
|||
![]()
Here's what I want to do in a Workbook: In Worksheet2 B7 (5-digit ZIP) go to Worksheet3 Column A (5-digit ZIP) & MATCH then for row, import Column B data (Post Office Name) to Worksheet2 G7.
![]() I am not knowledgeable or experienced using VLOOKUP (I think this is the function I should use). I tried several formulas from online tutorials but I only get errors. I want to use this function in numerous other areas of my workbook and the data type differs if that is pertinent. ![]() Can someone advise me of the formula for this one particular function above? (If you are willing, I would like to understand the syntax of the formula since I may need to modify it for the other desired areas. ![]() Thanks! Keith |
#2
|
||||
|
||||
![]()
Probably an array formula using INDEX/MATCH Please post a sample sheet ( no pics please)
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
![]()
I have tried to attach a copy of the workbook with personal information removed, worksheets deleted, etc. but it still exceeds the maximum file upload size. Any suggestions? Thanks, Keith
|
#4
|
||||
|
||||
![]()
Post a sample not an entirte wbook
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#5
|
|||
|
|||
![]()
Sample file attached.
As a result of making a sample, the original worksheets in the sameple are not correct. The original workbook had four sheets and my instructions were working from 2 through 4. Thanks, Keith |
#6
|
||||
|
||||
![]()
Could you please show the expected result? I can't find two sheets with ZIP codes
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#7
|
|||
|
|||
![]() Quote:
Here are the desired functions I want to perform: On WS1 take data in B4 Look up match in W2 Col A Take data in Cols B & C & import to WS1 G4 & H4 Take WS1 C4 Look up match in Col A Take data in Cols B & C & import to WS1 I4 & J4 Thanks, Keith |
![]() |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
teza2k06 | Excel | 2 | 03-18-2014 01:21 PM |
![]() |
Catbert | Excel | 18 | 08-25-2013 07:38 PM |
![]() |
ladygogo78 | Excel | 3 | 10-22-2012 12:28 AM |
IF + VLOOKUP formula help | skyline255 | Excel | 0 | 09-19-2012 05:05 PM |
Help with VLOOKUP formula | pattyr | Excel | 6 | 08-20-2012 02:20 AM |