copy a cell value based on search of another cell

  • Thread starter Thread starter Pendal
  • Start date Start date
P

Pendal

I have a worksheet that has two sheets to it

on sheet A i have a list of product codes and the name of an image that goes
with them

on sheet B i have a list of products codes and the productID number from my
database.

what i need to do is search sheet B for the product code that matches sheet
A and then insert the productID onto sheet A

is there an easy way to do this?

Thanks,
 
You can use VLOOKUP for this, or an INDEX/MATCH combination. Give us
some idea of which columns you are using on the sheets if you want a
specific formula to do it.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update cell value based on name and specific date 1
Copy corresponding cell in Column B if cell in A contains certain text? 1
Excel If a Cell Contains a Certain Text (From Another Table) 0
Excel How to Autocomplete text/string within a single cell, between different worksheets 1
How can I reference a worksheet in a formula based on a cell value 2
use month in cell date to sum all relevant cells 2
Excel VBA to move cells to sheet2 based on selection in sheet1 0
Collapsing all groups 0

Back
Top