Forum Discussion
Auto-filling column data
Hi,
I'm hoping to have help with an issue I've run into. I have columns A and B in one tab, which has the following data :
| Dog | Blue |
| Cat | Red |
| Turtle | Green |
On the second tab, I have the following table :
| Animal | Color |
| Dog | |
| Cat | |
| Turtle | |
| Dog | |
| Cat | |
| Turtle | |
| Dog | |
| Dog | |
| Dog |
Is there a way to insert a function that looks to the first table, then autofills column B in the second table, so the colors would be filled in automatically?
This is an example, but my list A is about 400 items and my list B is about 2000, so it would take a long time to fill in manually.
2 Replies
berhardt93 =VLOOKUP(A2,Sheet1!$A$1:$B$3,2,FALSE)
where this table is on Sheet 1 tab from A1 till B3
Dog Blue Cat Red Turtle Green and second table is on Sheet 2.
- Use Vlookup formula
