Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare data
Dear All, please help me, it is very important for me.
i must input the data every day and check the status. i use Excel, (I input data) (info from computer central) Colum A Colum F Colum G ColumH x125s x582b Pickced 11h00am x582b x596v Out 11h25am x125s In 09h40am ..etc If Colum A had found the info from Colum F, the display the status" Pickced, In or Out" and time exemple in Colum B display x125s In 09h40am x582b Pickced 11h00am Thank you so much. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare data
You can use =vlookup()
in B1: =vlookup(a1,F:g,2,false) and in C1: =vlookup(a1,F:g,3,false) If there is no match, you'll see an error. You can hide the errors by modifying your formula: =if(isna(vlookup(a1,F:h,2,false)),"Missing",vlooku p(a1,F:h,2,false)) If you're using xl2007 or higher: =iferror(vlookup(a1,F:h,2,false),"missing") Debra Dalgleish has lots of notes: http://www.contextures.com/xlFunctions02.html (for =vlookup()) and http://contextures.com/xlFunctions02.html#Trouble tran1728 wrote: Dear All, please help me, it is very important for me. i must input the data every day and check the status. i use Excel, (I input data) (info from computer central) Colum A Colum F Colum G ColumH x125s x582b Pickced 11h00am x582b x596v Out 11h25am x125s In 09h40am ..etc If Colum A had found the info from Colum F, the display the status" Pickced, In or Out" and time exemple in Colum B display x125s In 09h40am x582b Pickced 11h00am Thank you so much. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare data
Dear Dave Peterdon,
Thanks you so much. "tran1728" wrote: Dear All, please help me, it is very important for me. i must input the data every day and check the status. i use Excel, (I input data) (info from computer central) Colum A Colum F Colum G ColumH x125s x582b Pickced 11h00am x582b x596v Out 11h25am x125s In 09h40am ..etc If Colum A had found the info from Colum F, the display the status" Pickced, In or Out" and time exemple in Colum B display x125s In 09h40am x582b Pickced 11h00am Thank you so much. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare 2 data set | Excel Worksheet Functions | |||
Compare data and automatically enter data. | Excel Discussion (Misc queries) | |||
how to compare a list of data that is same as the main data sheet | New Users to Excel | |||
Compare Data | Excel Discussion (Misc queries) | |||
COMPARE DATA FOR CHANGES | Excel Worksheet Functions |