SOLVED

# Excel Formula To Copy Value From One Worksheet Into Cell On Another Sheet

Copper Contributor

# Excel Formula To Copy Value From One Worksheet Into Cell On Another Sheet

I'm hoping this can be done. I'm working and editing some old data to be imported into an Access database. What I would like to do is this:

Sheet 1 has two columns: 1A, 1B

Sheet 2 has two columns: 2A, 2B

The formula will go into a cell in column 2B and should do the following:

- Look up the value in the adjacent 2A cell in the row

- Find the row with the matching value in column 1A

- Copy the value of the row adjacent cell in 1B and paste it into the 2B cell

I hope that makes sense, I'm not sure how to put what I'm wanting to do into words! I'm pretty novice at Excel functions. Thanks!

2 Replies
best response confirmed by chemguy120 (Copper Contributor)
Solution

# Re: Excel Formula To Copy Value From One Worksheet Into Cell On Another Sheet

You can use XLOOKUP in 2B

=XLOOKUP(2A, 1A, 1B, "")

# Re: Excel Formula To Copy Value From One Worksheet Into Cell On Another Sheet

Thanks so much for a quick reply! Worked like a charm!!!!
1 best response

Accepted Solutions
best response confirmed by chemguy120 (Copper Contributor)
Solution

# Re: Excel Formula To Copy Value From One Worksheet Into Cell On Another Sheet

You can use XLOOKUP in 2B

=XLOOKUP(2A, 1A, 1B, "")