if-statement: Excel using proper formula, Lookup vs Vlookup vs IF

vendredi 29 janvier 2016

Trying to write a formula for Excel, Using 2 worksheets. to classify the invoices

Worksheet 1 has Group Name and Group ID

Worksheet 2 has Group Name, invoice amount,invoice number

Trying to get the Group ID to worksheet 2, keeping in mind a ID can be use multiple times

Using formula below but the IDs I'm getting back aren't matching

=LOOKUP(F2,GROUP!C:C,ID!B:B)

Any help would be appreciated

if-statement