Forum Discussion
Autofill Data analyst Clients Name and Number
Yes! You need to use a lookup. If you have office 365, xlookup will be the best. Otherwise vlookup will be fine but the formula will differ slightly.
You'll have to adapt this to your workbook but this should do what you're looking for:
=+XLOOKUP(A5,$A$2:A4,$B$2:B4,"")
This looks up the name next to the formula for a matching name that's been previously entered. It then pulls the number in after. You can do this for any column or data that you need.
DKoontz Can you explain this formula a bit more? sorry, pretty new to formulas in excel.
whats the best means of adapting it to my workbook its currently A84 B84 C84 D84
A = Name B= Contact Number C= Staff member D = Matter
Cell 1 is the announcement of columns
and im wanting it to be forever continuing. may also be because i haven't eaten yet, ill see if i can figure it out after lunch.
Thanks for your help 🙂
Kind reguards
Keith