Not Able to Find Value Using vLookup or xLookup

[Gsugihara]

Please see this first pic with the formula.

Excel Sheet 1 with Formula .jpg

Then look at the second pic with my array.

Excel Sheet 2 with Table Array.jpg

I can't get the formula to show what type of office the user has.

[FDibbins]

Rather than show a pic - which can be hard to read and does not show actual underlying cell contents, please upload a SMALL representative file - see yellow banner above on how to do that.

[menem]

Normally, I don't use vlookup in this pattern.
Your formula (vlookup) were placed on 'Gavain query for HMC' but first parameter was come from another sheet ( 'HMC O365 License Order' ) and looked data from 'Gavain query for HMC'.

I'm always place the formula in the same sheet of first parameter's sheet.

Regards.

[Gsugihara]

Sorry about that. Here's a test datasheet.Test Data for Excel Forum.xlsx

[FDibbins]

1. Your file contains links to outside sources.

2. only 1 entry in sheet 2 matches anything on sheet 1

3. Try this in sheet 2 ...
D2 =VLOOKUP(A2,'Gavin query for HMC'!$A$2:$C$11,3,0)
copied down