Need Help Please=)

DGuy92034

New Member
Joined
Sep 10, 2014
Messages
5
I want to be able to put in an account number in an empty cell and have it pull the contents from a row that contains the account number.

If enter the account number into the empty cell, it will go find the account number on a separate tab and return with all the information in that row. Is this possible?

THANKS!
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Momentman

Well-known Member
Joined
Jan 11, 2012
Messages
4,142
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
You might need the VLOOKUP function but without much info, thats the best i can say :)
 

ExcelMercy

Board Regular
Joined
Aug 11, 2014
Messages
151
Sample data we can help you write it.

Vlookup or Match/Index sounds like they would both work.
 

DGuy92034

New Member
Joined
Sep 10, 2014
Messages
5
I have a excel workbook that contains 2 sheets. The first sheet, in cell A1, I want to put and account number. After, I enter the account number (and hit enter), I want it to find the account number on the second sheet and return all the information in that row (from the 2nd sheet) back to the first sheet, in Row 2.
 

DGuy92034

New Member
Joined
Sep 10, 2014
Messages
5

ADVERTISEMENT

It would find the account number in the 4th column and return the contents of the row that contains the account number, sorry kind of new to excel=)

DAILY COUNTCALLER NAMETIME OF CALLACCOUNT NUMBERGML REF #CLIENT ID/ NAMEZIPPICK UP LOCATIONFSR NAMETIME OF DISPATCHCONFIRMATION FROM FSRDELIVERY LOCATIONPICK UP TIMEDELIVERY TIME
1 10 33606HEART CARE CENTER 14320 BRUCE B DOWNS ** IN BILLING OFFICE TPA LAB
1 66008140 32570FL Dept of Health - 5527 Stewart St, Milton, FL Milton Patient Service - 5950 Berryhill Rd, Milton, FL
1 10 33606QUEST 4225 E FOWLER AVE TO: USF STUDENT HEALTH SERVICES 4107 CEDAR HILLS DRIVE STE 100 TGH
<colgroup><col width="61" style="width: 46pt; mso-width-source: userset; mso-width-alt: 2230;"> <col width="74" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2706;"> <col width="65" style="width: 49pt; mso-width-source: userset; mso-width-alt: 2377;"> <col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;"> <col width="93" style="width: 70pt; mso-width-source: userset; mso-width-alt: 3401;"> <col width="90" style="width: 68pt; mso-width-source: userset; mso-width-alt: 3291;"> <col width="89" style="width: 67pt; mso-width-source: userset; mso-width-alt: 3254;"> <col width="197" style="width: 148pt; mso-width-source: userset; mso-width-alt: 7204;"> <col width="80" style="width: 60pt; mso-width-source: userset; mso-width-alt: 2925;"> <col width="77" style="width: 58pt; mso-width-source: userset; mso-width-alt: 2816;"> <col width="68" style="width: 51pt; mso-width-source: userset; mso-width-alt: 2486;"> <col width="97" style="width: 73pt; mso-width-source: userset; mso-width-alt: 3547;"> <col width="80" style="width: 60pt; mso-width-source: userset; mso-width-alt: 2925;"> <col width="90" style="width: 68pt; mso-width-source: userset; mso-width-alt: 3291;"> <tbody> </tbody>
 

ExcelMercy

Board Regular
Joined
Aug 11, 2014
Messages
151
Do you want all the contents from sheet2's column associated with the account number condensed to a single column on sheet1?

Or do you want all the accompanying information to have their own column on sheet1?
 

Momentman

Well-known Member
Joined
Jan 11, 2012
Messages
4,142
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
For columns to the right of the Account number column, A vlookup would work, for those to the left of that column, a vlookup would fail and you have to resort to INDEX-MATCH

I have picked out some columns and you will see the formula that extracts the data


Excel 2010
ABCDE
1ACCOUNTNUMBERZIPPICK UP LOCATIONDELIVERY LOCATIONDAILY COUNT
26600814032570FL Dept of Health - 5527 Stewart St, Milton, FLMilton Patient Service - 5950 Berryhill Rd, Milton, FL1
Sheet2
Cell Formulas
RangeFormula
B2=VLOOKUP($A$2,Sheet1!$D$1:$N$4,4,0)
C2=VLOOKUP($A$2,Sheet1!$D$1:$N$4,5,0)
D2=VLOOKUP($A$2,Sheet1!$D$1:$N$4,9,0)
E2=INDEX(Sheet1!$A$1:$D$4,MATCH(Sheet2!A2,Sheet1!$D$2:$D$4,0),1)


and the raw data is of course

Excel 2010
ABCDEFGHIJKLMN
1DAILY COUNTCALLER NAMETIME OF CALLACCOUNT NUMBERGML REF #CLIENT ID/ NAMEZIPPICK UP LOCATIONFSR NAMETIME OF DISPATCHCONFIRMATION FROM FSRDELIVERY LOCATIONPICK UP TIMEDELIVERY TIME
211033606HEART CARE CENTER 14320 BRUCE B DOWNS ** IN BILLING OFFICETPA LAB
316600814032570FL Dept of Health - 5527 Stewart St, Milton, FLMilton Patient Service - 5950 Berryhill Rd, Milton, FL
411033606QUEST 4225 E FOWLER AVE TO: USF STUDENT HEALTH SERVICES 4107 CEDAR HILLS DRIVE STE 100TGH
Sheet1
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,300
Messages
5,836,489
Members
430,435
Latest member
Benforest1

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top