Vlookup between sheets

You just use many VLOOKUPS, with different column offsets.

Originally Posted by Jordans121

I want to use sheet1 (Column D) as vlookup (for 3 numbers. EX. 154) for another sheet called "CA". I then want all of the info from that row in sheet1 to be copied to CA. Hope this is possible.

Note: the 3 numbers that i will be searching for in sheet1 comes from "CA" column D

Also every number from 000-999 is covered in sheet1

unfortunately you have not supplied enough information for us to solve this. Please upload the two sheets with sample data in them so we can help you solve this issue.