Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help
Hello I wonder if anyone can help me with this problem please. I have and excel file that is used to monitor the progress of some 200 products, when they come into the shop for servicing and repair. Sheet 1 consists of customer details, product and serial number. Sheet 2 is the complete list of products and serial numbers. Sheet 3 consists 20 of the top priority products. I would like to put a formula by the side of the product serial number in sheet 3, to search sheet 1 Column J for corresponding serial number and same row column A for a negative number if found, show “In”. The product serial number is made up of numbers and letters. Thanks -- oldbiscaya ------------------------------------------------------------------------ oldbiscaya's Profile: http://www.excelforum.com/member.php...o&userid=34419 View this thread: http://www.excelforum.com/showthread...hreadid=542482 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help
You can use VLOOKUP across worksheets, but I donno how to do 2 separate columns - maybe nest it with an IF function? this might work on Sheet 3 (assumes Col. S has the serial number): =VLOOKUP(s1,Sheet1!J$1:J$200,1,FALSE) This ONLY returns a matching Serial Number, and nothing else. If there is no Serial Number match you get a "N/A" in the cell Any slide rule kids out there know the real answer? Hope this helps (half way). Mark Boston, MA -- LTUser54 ------------------------------------------------------------------------ LTUser54's Profile: http://www.excelforum.com/member.php...o&userid=33459 View this thread: http://www.excelforum.com/showthread...hreadid=542482 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Nesting questions | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |