Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need help with a simple vlookup formula
I have a workbook with two worksheets in it worksheet A contains (starting in row 2) A - Product ID B - Part Number C - List Price D - Customer Price worksheet B contains (starting in row 2) A - Part Number B - Price I need to put a formula in the customer Price cell of worksheet A that will lookup the matching part number in worksheet B and use the price in cell b of worksheet B to populate cell d of worksheet A. I get daily price updates from a vendor daily and need a way to update prices on over 4,000 products with the updates they send me. Thanks in advance, Sincerely pj -- phjohnso ------------------------------------------------------------------------ phjohnso's Profile: http://www.excelforum.com/member.php...o&userid=37403 View this thread: http://www.excelforum.com/showthread...hreadid=571140 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need help with a simple vlookup formula
Assuming Worksheet B is in the same workbook as Worksheet A this should work: In column D of worksheet A =VLOOKUP(B1,Worksheet B!A1:B65535,2,TRUE) and copy the formula down the D column Remember Worksheet B must be in ascending order -- Special-K ------------------------------------------------------------------------ Special-K's Profile: http://www.excelforum.com/member.php...fo&userid=7470 View this thread: http://www.excelforum.com/showthread...hreadid=571140 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need help with a simple vlookup formula
Try this:
=VLOOKUP(B2,SheetB!$A$2:$B$4000,2,0) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "phjohnso" wrote in message ... I have a workbook with two worksheets in it worksheet A contains (starting in row 2) A - Product ID B - Part Number C - List Price D - Customer Price worksheet B contains (starting in row 2) A - Part Number B - Price I need to put a formula in the customer Price cell of worksheet A that will lookup the matching part number in worksheet B and use the price in cell b of worksheet B to populate cell d of worksheet A. I get daily price updates from a vendor daily and need a way to update prices on over 4,000 products with the updates they send me. Thanks in advance, Sincerely pj -- phjohnso ------------------------------------------------------------------------ phjohnso's Profile: http://www.excelforum.com/member.php...o&userid=37403 View this thread: http://www.excelforum.com/showthread...hreadid=571140 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need help with a simple vlookup formula
perfect - thanks for the help sincerely pj -- phjohnso ------------------------------------------------------------------------ phjohnso's Profile: http://www.excelforum.com/member.php...o&userid=37403 View this thread: http://www.excelforum.com/showthread...hreadid=571140 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
If / Vlookup Formula Help €¦!! | Excel Discussion (Misc queries) | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
IF / VLOOKUP formula won't work until saved | Excel Worksheet Functions | |||
How do I use Range Names listed in a VLookup table in a formula? | Excel Worksheet Functions |