Fill in if..

[Guest]

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.

 

[Bob Phillips]

look at VLOOKUP, or MATCH and INDEX in help.

--
HTH

Bob Phillips

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

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.

 

[Bob Phillips]

look at VLOOKUP, or MATCH and INDEX in help.

--
HTH

Bob Phillips

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

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.

 

[Guest]

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

 

[Guest]

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

 

[shail]

hi Cindy,

Try using VLOOKUP as below

=VLOOKUP(A1,Master_Info!A112,2,FALSE)

I am assuming :
1. Your data is in the range of A1 till D12.
2. You want to lookup A1 of the Monthly Orders sheet with Master Info.
3. You want to get the data at the 2nd column from the leftmost of your
data.

Try using VLOOKUP this way and you will get the desired output.

Hope this works for you.

thanks,

Shail

 

[shail]

hi Cindy,

Try using VLOOKUP as below

=VLOOKUP(A1,Master_Info!A112,2,FALSE)

I am assuming :
1. Your data is in the range of A1 till D12.
2. You want to lookup A1 of the Monthly Orders sheet with Master Info.
3. You want to get the data at the 2nd column from the leftmost of your
data.

Try using VLOOKUP this way and you will get the desired output.

Hope this works for you.

thanks,

Shail