Forum Discussion
berhardt93
Dec 15, 2020Copper Contributor
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, ...
0rtli
Dec 15, 2020Copper Contributor
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.