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

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
You might need the VLOOKUP function but without much info, thats the best i can say :)
 
Upvote 0
Sample data we can help you write it.

Vlookup or Match/Index sounds like they would both work.
 
Upvote 0
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.
 
Upvote 0
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>
 
Upvote 0
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?
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,216,481
Messages
6,130,922
Members
449,606
Latest member
jaybar0812

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
Back
Top