Main Area and Open Discussion > General Software Discussion

autofill in EXCEL

<< < (3/4) > >>

dluby:
You were correct, our strict firewall has blocked access to Imageshack  >:(

katykaty:
First thing that springs to mind is HLOOKUP - because presumably your source data will be horizontal rows by name?

kalos:
thanks
is it easy for anyone to post what I should write in excel to do this? I am not familiar at all with LOOKUP commands

David1904:
Here is an example of using vlookup.
You need to create the list of data first - sort by the first field (the one you will be using for reference), then name it (Alt/insert/name/define)
Use insert function and fill in the boxes.

Here is an image (I hope!) that shows the end result. Use Ctrl` (Control grave) to toggle between showing formula and text

kalos:
mm, I entered all that text in an excel, but what should I short exactly? list F?
also, what should I name exactly and how?

I get this error:
autofill in EXCEL

Navigation

[0] Message Index

[#] Next page

[*] Previous page