Formula - Return text from a column if two other columns match

[ChrisMac1]

Hi there, and thanks for taking the time to look at my request.

I have a doc that has two sheets named VOR_Log (1) and Sheet1.

I need a formula in column B2 of sheet 'VOR_Log (1)' that will look at the text in column A2 of sheet 'VOR_Log (1)' for matching text in column D of sheet 'Sheet1'. If a match is found I want the value in column H of 'Sheet1' brought over.

I hope that makes sense, many thanks for any help.
Chris

 

[ChrisMac1]

Maybe another way to say this is where a value in column A of sheet 'VOR_Log (1)' matched the value in column D of sheet 'Sheet1', return the text in column H of 'Sheet1'.

 

[Fluff]

How about

=xlookup(a2,Sheet1!d2:d1000,Sheet1!h2:h1000)

 

[ChrisMac1]

Hi Fluff Worked and absolute treat, thanks so much!!

 

[Fluff]

You're welcome & thanks for the feedback.