Forum Discussion

Copper Contributor

Nov 23, 2022

Solved

Using VBA to search and fill data between 2 sheets

Looking for input on if I might be getting in over my head for a VBA beginner. I have worksheets that have project numbers on my "Awards" sheet and people working on (potentially multiple) projec...

Macros and VBA

HansVogelaar
Nov 23, 2022
DBlackwood

In R2 on the Effort sheet:

=XLOOKUP(B2, Awards!A:A, Awards!R:Z, "")

Fill down.

HansVogelaar

MVP

Nov 23, 2022

DBlackwood

In R2 on the Effort sheet:

=XLOOKUP(B2, Awards!A:A, Awards!R:Z, "")

Fill down.

DBlackwood
Copper Contributor
Nov 24, 2022
Oh my goodness.... I figured I was missing some basic formula that already existed to do something like that! You are a magical person, Hans. Thank you much!