Microsoft Office Forums - View Single Post - [Solved] Look up data

Thread: [Solved] Look up data

View Single Post

Old

06-25-2016, 09:44 AM

KunleExcel KunleExcel is offline

KunleExcel is offline

KunleExcel uses Windows 8

Windows 8

KunleExcel uses Office 2010 32bit

Office 2010 32bit

Novice

Join Date: Jun 2016

Location: Nigeria

Posts: 17

KunleExcel is on a distinguished road

Default

Look up

=INDEX(array:location column in Table2,MATCH(lookup_value:name in Table1,lookup_array:column containing names in Table2,match_type:0))

Reply With Quote