I HAVE TRIED ALL THIS I JUST CANT FIGURE THE RIGHT FORMULA

"Bob Phillips" wrote:

look at VLOOKUP, or MATCH and INDEX in help.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"CINDY" wrote in message
...
I HAVE TWO SHEETS ONE FOR MASTER INFO AND ONE FOR MONTHLY ORDERS I NEED TO
HAVE THE MONTHLY ORDERS SHEET TO GRAB INFOR FROM MASTER SHEET IF IT
MATCHES.