vlookup to retun multiple column values against multiple columns

Hi

I have tried to find the answer to this but it seems that most of the answers are not exactly like my request...

So I have one sheet of data, lets call this Hardware1 (all columns are populated)

Item make model serial build location
server1
server2
server3
server4

and another sheet of data, lets call this hardware2

Item make model serial build location
server1 hp etc 1234 etc florida
server2 solaris 1234 mahve desert
server3 dell 1234 chippingnorton
server4 hp


I would usually do this using one lookup formula in each column to retrieve each colums data. For example to find the make for each server, it would look something like this - =vlookup(hardware1!A2:A1378,B2:B1378,2,false) I would drag the formula down so all servers have their make populated. Then I would do this again in the model column and repeat for each column

I would like to update the columns for make model, serial etc of sheet hardware1 with the information from hardware2 using only one lookup/formula so I don't have to have to do multiple lookups each time,.

many thanks!

thanks Ive have added a sheet showing the two hardware tabs and a desired results sheet showing an example of how I would do it with multiple lookups

I would like to update hardware1 with any changes that appear in hardware2

So the desired results sheet shows 3 lookups in each column, showing the server names from hardware1 and the updates to make model or serial from hardware2

I would like if possible one formula to show these results, rather than writing

3 lookups (or in reality, a whole lot more in a sheet with many columns)

thanks

oh no, ok thanks for your help anyway

Update to Glenn's formula:

=IFERROR(VLOOKUP($A$2:$A$23,hardware2!$A$2:$D$19,COLUMNS($A:B),FALSE),VLOOKUP($A$2:$A$23,hardware1!$A$2:$D$19,COLUMNS($A:B),FALSE))

If no data in Hardware2, then use Hardware1.