If or Match 1 unique number to return another number 2 different problems

Good afternoon

not sure which would be the best way to use excel to look up the problem I have below

I have attached a sheet with problem 1 and 2 and in the red is the correct returned table

I have a list of Lp's numbers from 5 numbers long to up to 10 numbers long with a product name next to it
and a Loc row that we want to be able to auto fill in

Row A 1:24 to H 1:24 table
I have to scan all my pallets in to our rack and the scanner we have saves this info in a excel sheet there are 2 ways it saves it being able to have both problems working would help a lot

first problem is
LP in Row A product name in row B Row G are LP numbers and any random order and in cell H is the loc
I would like the LP in Row A to match Row G and return H in to Row C

Row A will never have the same number twice
Row G might if we scan the LP twice Should have same Loc as the above LP if scanned twice the guns dont have a screen to see so driver might scan it again it they forgot or miss scanned

2nd problem
Row A 29:48 F 29:67

The Problem this time is the LP and the Loc are in the same row
Lp first then Loc under

Row C looks up Row A matches LP in Row F and returns Number Loc below LP From A to Row C
same as above but all the info is in 1 row not 2

any help would be great

Thanks for your time and Support

Thanks Benishiryo

you are the best
I have problems with the index and match matching up the lines

do you have some thing like the vlookup guide for index and match

I looked over it great support

Thanks for all your time and support

JustinwB