I have work sheets for different equipment that I need to find matching part numbers on if they exist. What I need to do is use information on sheet 1 cell c3 and search sheet 2 collum c to see if that information exist. This will then be repeated for each cell in sheet 1 collum c. If the information exist I then need to know where it is.
Thanks
sample.xls
Hi ROCKCHOPPER,
Search the forum for "Vlookup"
Maybe this example can help
http://www.excelforum.com/attachment...her-sheets.zip
Place this formula in D3 and drag the formula down
=IF(ISERROR(VLOOKUP(C3,'Sheet1 (2)'!$C$3:$H$176,2,0)),"No Part Exists",VLOOKUP(C3,'Sheet1 (2)'!$C$3:$H$176,2,0))
Last edited by davesexcel; 08-30-2008 at 11:11 AM.
That seems to work. Thanks a lot. The only thing I need is to be told the location of the line that was found. I need sheet and row if possible. Is there a way to make this search up to 5 sheets. Hope I'm not asking to much! Thanks
Dave I have used this formula a lot thanks!!
Now is it possible to copy the information without copying the formulas? I need to transfer the results of the VLOOKUP on a different excel.
You can copy the range and then paste special values, this will just paste the values and not the formulas...Originally Posted by ROCKCHOPPER
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks