Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup function .... I think???
Hello, this is what I have. sheet 1 ID(A) Item #(B) CAFRLT G804170619 CAFRLT G805170652 CAFRLT G812170652 CANGEO G804170619 CANGEO G805170652 CANGEO G812170652 sheet 2 ID(A) G804170619 (B) G805170652(C) G812170652(D) CAFRLT $1,057.26 $949.50 $114.40 ALFPET $0.00 $0.00 $0.00 CAWERE $0.00 $0.00 $0.00 CANGEO $265.30 $211.50 $27.20 CARAVE $435.10 $557.10 $30.40 what I need is a formula in sheet 1 that will go and look for the ID and the Item Code and give a corresponding value. I can't make it work to save my life. Any help would be greatly appreciated. Thanks -- cameronfunk ------------------------------------------------------------------------ cameronfunk's Profile: http://www.excelforum.com/member.php...o&userid=34569 View this thread: http://www.excelforum.com/showthread...hreadid=547135 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup function .... I think???
Hi Cameron How about something like this: =VLOOKUP(Sheet1!A2,Sheet2!$A$2:$D$1000,MATCH(Sheet 1!B2,Sheet2!$B$1:$D$1,0),0) Ranges will need adjusting to suit. Best regards Richard -- RichardSchollar ------------------------------------------------------------------------ RichardSchollar's Profile: http://www.excelforum.com/member.php...o&userid=34698 View this thread: http://www.excelforum.com/showthread...hreadid=547135 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup function .... I think???
Had some problems with the text but all worked out in the end. I knew it would work and you proved me right. Thanks so much. -- cameronfunk ------------------------------------------------------------------------ cameronfunk's Profile: http://www.excelforum.com/member.php...o&userid=34569 View this thread: http://www.excelforum.com/showthread...hreadid=547135 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
numerical integration | Excel Discussion (Misc queries) | |||
Lookup Function help | Excel Discussion (Misc queries) | |||
Lookup Function Problems | Excel Worksheet Functions | |||
lookup function 1 | Excel Worksheet Functions | |||
How do I use 3 cells to create the string for a lookup function? | Excel Worksheet Functions |