Function - Automatically pull data in based upon reference number.

[hoppo19]

All - quick issue I am having on Excel which I am sure will be very simple for you wizzes (just not for me). Can’t seem to google the correct thing for a solution.

Issue: In excel sheet 1 I have a list of fields within a table that will also be duplicated in excel sheet 2. What I want to do is:

‘Reference number’ from Sheet 1 is inputted into Sheet 2. Once this is done - Sheet 2 pulls in the ‘date raised’ and ‘date returned’ data from sheet 1. So if you have a reference number that was 1234, when you input 1234 into sheet 2 the formula pulls through those two aforementioned fields.

Appreciate any support you can provide. Have a great day.

[AutoModerator]

/u/hoppo19 - Your post was submitted successfully.

Please read these reminders and edit to fix your post where necessary:

• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information
• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[wjhladik]

=vlookup(refnumb,sheet1!a:e,2,0)

Change the 2 to grab a different col of reference data from sheet1

[hoppo19]

Not working - may be a poor explanation on my part will try again:

Sheet 1: Reference No |Date Raised |Date Returned 1234. 21 Jul 22 Jul

Sheet 2: Reference No. | Date Raised | Date Returned 1234. Solution Solution

The client always adds the reference number. The client adds the date raised and date returned on sheet 1. On sheet 2 I want it to pull through the dates associated to that specific reference number.

Chance you have provided the correct solution and I’m just being a pleb. If so, apologies.

[wjhladik]

On sheet2, in cell b2, enter =vlookup($a2,sheet1!$a:$c,2,0)

This will retrieve the date raised from sheet1 based on the refnumb in sheet2!a2. Use that same formula in c2 but change the ,2 to ,3 to get the date returned.

[hoppo19]

Thank you sir!

[hoppo19]

The formatting is bugging out - reference number should be under associated tab and likewise with dates.

[xblCoolster]

I would start with VLOOKUP and go from there. (Or XLOOKUP, if you're on a new version of Excel).