google spreadsheet - VLookup arranged into cell based on neighbor cell -

i looking way vlookup call information google sheet 2 google sheet 1. specifically, if cell h in 'google sheet 1' matches cell in 'google sheet 2', put information cell b in 'google sheet 2' corresponding row in 'google sheet 1'.

example below:

before function:

google sheet 1: h 1 eng#1 (blank) 2 eng#2 (blank) 3 eng#3 (blank) 4. eng#4 (blank)

google sheet 2: b 1 eng#1 .4 2 eng#2 .1 3 eng#4 .7 4. eng#7 .3 5. eng#3 .2

result seeking:

google sheet 1: h 1 eng#1 .4 2 eng#2 .1 3 eng#3 .2 4. eng#4 .7 5. eng#7 .3

i appreciate assistance this, way increase efficiency , tracking group of people.

it sounds need combine vlookup , importrange. try like:

=arrayformula(if(h:h="",,vlookup(h:h,importrange("sheetkey","sheet1!ab:ac"),2,0)))

note may necessary try importrange on own first, ensure sheets have correct access each other.