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 |
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 |
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 |
All times are GMT +1. The time now is 09:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com