XLOOKUP

Hi Matthew,

Thank you for the forum question.

XLOOKUP is perfect for what you're trying to achieve. Here's a step-by-step guide to help you set this up:

Identify Your Sheets and Fields:

Let's call the sheet with highlighted grant proposals Sheet1.
The sheet with background information will be Sheet2.
The third sheet where you want to insert the selected records will be Sheet3.
Set Up XLOOKUP in Sheet3:

In Sheet3, you'll use XLOOKUP to pull data from Sheet2 based on the reference numbers in Sheet1.
Write the XLOOKUP Formula:

Suppose the reference numbers in Sheet1 are in column A, starting from A2.
The reference numbers in Sheet2 are also in column A, and the data you want to pull starts from column B.
Here's an example formula to pull data from Sheet2 into Sheet3:

=XLOOKUP(Sheet1!A2, Sheet2!A:A, Sheet2!B:B)
This formula will look for the reference number in Sheet1 (A2) within Sheet2 (column A) and return the corresponding value from column B of Sheet2.

Copy the Formula Across and Down:

Drag the formula across to cover all the fields you want to pull from Sheet2.
Drag the formula down to cover all the reference numbers in Sheet1.
Adjust for Multiple Fields:

If you need to pull multiple fields, adjust the formula accordingly. For example, to pull data from columns B, C, and D in Sheet2, you can use:
=XLOOKUP(Sheet1!A2, Sheet2!A:A, Sheet2!B:D)
Insert Data into Sheet3:

Once you have the formulas set up, the data will automatically populate in Sheet3 based on the reference numbers in Sheet1.





Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector