| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
look up a list and return a value
i need to update my price book. i have my price list in 1sheet and download
my new pricing into another sheet. i need to look up the manuf name in my price book and return the new cost from the download sheet.. can any one help |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
look up a list and return a value
Assuming that the downloaded list is structured name, cost, then you can use
VLOOKUP =VLOOKUP(Sheet1!A1,Sheet2!A1:B1000,2,False) where A1 holds the name to lookup. Obviously, the A1:B1000 should adjust to whatever your limits are. -- HTH RP (remove nothere from the email address if mailing direct) "Carept Guy" wrote in message ... i need to update my price book. i have my price list in 1sheet and download my new pricing into another sheet. i need to look up the manuf name in my price book and return the new cost from the download sheet.. can any one help |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
look up a list and return a value
Also, make sure the a1 column in sheet2 is sorted alphabetically. This makes
a world of difference to that command. Greg "Bob Phillips" wrote in message ... Assuming that the downloaded list is structured name, cost, then you can use VLOOKUP =VLOOKUP(Sheet1!A1,Sheet2!A1:B1000,2,False) where A1 holds the name to lookup. Obviously, the A1:B1000 should adjust to whatever your limits are. -- HTH RP (remove nothere from the email address if mailing direct) "Carept Guy" wrote in message ... i need to update my price book. i have my price list in 1sheet and download my new pricing into another sheet. i need to look up the manuf name in my price book and return the new cost from the download sheet.. can any one help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return value from list many conditions | Excel Worksheet Functions | |||
| return largest number of a list of numbers in the same cell | Excel Worksheet Functions | |||
| Function to check list for specific conditions and return an answe | Excel Discussion (Misc queries) | |||
| Using a Vlookup to return values in a data list? | Excel Worksheet Functions | |||
| return a data list depending on a value selected within a drop dow | Excel Discussion (Misc queries) | |||
Linear Mode
