Look Up

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two worksheets. Each one is a list of PO#'s and info running
horizontally in columns. I want to use the PO# in sheet one to pull data from
worksheet two where the PO# matches.

All help appreciated! Thx!
 
are u sure your PO#'s are in the same format on both sheets? is the a space
in one sheet and not the other? you can copy same PO from both sheets and put
them equal together to see if you get TRUE if not you might have to use trim
in your formula.
 

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Combine Multiple Worksheets 2
SUMIF or SUMPRODUCT or ?? 2
Finding Multiple Entries & Deleting All but One 7
pulling certain characters from a string of text 3
How do I create a purchase order log in Excel? 1
Multiple subtotal rows 1
How to insert macro results on a separate spreadsheet in row order 1

Back
Top