Excel Match Formula

[Robert_Conklin]

I need an excel formula that will match the name from column E from the first spreadsheet to the name in column C from the second spreadsheet (both in the same workbook) and return the value in column D from the second spreadsheet.

 

[Peter_SSs]

I played around with the Index/Match combo and developed the following that worked:

=INDEX(Table15[Global ID],MATCH([@Name],Table15[Name],0))

Glad you got something that worked. (You didn't tell us before that your data was in 'formal' Tables though. )

=IFERROR(VLOOKUP(E2,'Giant List '!C$1:D$5,2,0),"Not found")

I tried a modified formula to encompass the actual arrays:

=IFERROR(VLOOKUP(E:E,'Company Wide Global ID & AD ID'!A:A,2,0),"Not found")

Even though I looked up a couple of the names to see if they were on the giant list, which they were, it still brought back 'Not Found'.

Just FYI, the reason this always returned "Not found" was that you modified it incorrectly in two ways:

1. By trying to put a whole column where and individual cell must go
   
   
2. By replacing what must be a multi-column range with a single-column range but still trying to reference the 2nd column of that range

Each of these would cause the VLOOKUP to error and hence the IFERROR result was returned.