Formula or Filter for Data Pull

Question

I have data in one sheet that I want to pull into a second sheet based on ID numbers.

I have added a link to my example google sheet and i'm hoping someone may be able to help, i'm a novice when it comes to these things and rather than individually go through tons of data line by line I was hoping there was an easier way to populate the data.

Link to Sheet

So for example I have a table like this in Sheet 1:

|ID Number| Vehicle Type| Wrap| Branding|

6906
6902
4600
5342

in Sheet 2, I have the same but the vehicle type, wrap and branding are populated, like so:

|ID No| Vehicle Type| Wrap| Branding|

|6906| ---Hybrid --- | -Blue | ---50----|

I want to pull the data from Sheet 2 and populate Sheet 1. In this example there are only 4 entries but the actual data I have to trawl has thousands of entries and the second sheet has ID numbers but in different orders.

How would be the best way to tackle this? Hope that all makes sense?

Thanks

Chris

Answer 1

Here's a generalized approach based on your description, this single array-style lookup formula goes into Cell_B2 of Sheet1 tab & pulls the data from Sheet2 accordingly based on ID No.

=map(A2:A,lambda(Σ,if(Σ="",,xlookup(Σ,Sheet2!A:A,Sheet2!B:D,))))