Excel Basics

From the source below can you find the Customer Number corresponding to the Account Name?

Answer
VLOOKUP won't work as Customer Num is to the LEFT of the Account Name. We need INDEX MATCH 📖Explanation
=INDEX(A2:D12,MATCH(F7,B2:B12),1)
Last modified 1mo ago