Lookup Formula Help Advanced?

[AustinK]

Hi there thanks for taking the time to read this. I am pretty good with excel formulas but this one has got me stumped. I have attached my actual template that i am working on right now and i will reference the exact cells from it.

I want to enter a Unit # on Unit # 0001 sheet in cell G1 that pulls data (year make model) from "UTV Master Sheet" and inserts it into cells B2, D2, and F2 on "Unit # 0001" sheet. I dont want to have to copy and paste every single unit info on every single sheet. I was hoping that this could actually be feasible and i am not expecting too much from Sheets.

I look forward to your quick responses and many thanks.

 

[p45cal]

B2:

=XLOOKUP(G1,'UTV Master Sheet'!G3:G21,'UTV Master Sheet'!C3:C21,"none")

D2:

=XLOOKUP(G1,'UTV Master Sheet'!G3:G21,'UTV Master Sheet'!D3:D21,"none")

F2:

=XLOOKUP(G1,'UTV Master Sheet'!G3:G21,'UTV Master Sheet'!E3:E21,"none")

 

[AustinK]

Thank you so much for the quick reply. This worked perfectly.