Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
free2bjmg
 
Posts: n/a
Default How to return a dollar value for a part number entered in a cell

Ihave a large number of part numbers with corresponding prices. I would like
to enter a part number in a cell and have the corresponding price returned to
the appropriate spot on the worksheet. I am using Excel 2002.
  #2   Report Post  
Biff
 
Posts: n/a
Default

Hi!

Part numbers in the range A10:A500

Corresponding price in the range B10:B500

A1 = part number to search for

B1 = formula:

=VLOOKUP(A1,A10:B500,2,0)

Biff

"free2bjmg" wrote in message
...
Ihave a large number of part numbers with corresponding prices. I would
like
to enter a part number in a cell and have the corresponding price returned
to
the appropriate spot on the worksheet. I am using Excel 2002.



  #3   Report Post  
Niek Otten
 
Posts: n/a
Default

Or, in case you'd like to copy the formula to other cells,

=VLOOKUP(A1,$A$10:$B$500,2,0)

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Biff" wrote in message
...
Hi!

Part numbers in the range A10:A500

Corresponding price in the range B10:B500

A1 = part number to search for

B1 = formula:

=VLOOKUP(A1,A10:B500,2,0)

Biff

"free2bjmg" wrote in message
...
Ihave a large number of part numbers with corresponding prices. I would
like
to enter a part number in a cell and have the corresponding price
returned to
the appropriate spot on the worksheet. I am using Excel 2002.





  #4   Report Post  
paul
 
Posts: n/a
Default

i would use the false 4 th argument as well,then it wiil find an exact match
and your part numbers do not have to be sorted in ascending order......ie
=VLOOKUP(A1,$A$10:$B$500,2,false)


--
paul
remove nospam for email addy!



"Niek Otten" wrote:

Or, in case you'd like to copy the formula to other cells,

=VLOOKUP(A1,$A$10:$B$500,2,0)

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Biff" wrote in message
...
Hi!

Part numbers in the range A10:A500

Corresponding price in the range B10:B500

A1 = part number to search for

B1 = formula:

=VLOOKUP(A1,A10:B500,2,0)

Biff

"free2bjmg" wrote in message
...
Ihave a large number of part numbers with corresponding prices. I would
like
to enter a part number in a cell and have the corresponding price
returned to
the appropriate spot on the worksheet. I am using Excel 2002.






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Seed numbers for random number generation, uniform distribution darebo Excel Discussion (Misc queries) 3 April 21st 23 09:02 PM
Assign a dollar amount to a corresponding number in a range of num slh Excel Discussion (Misc queries) 3 May 19th 05 01:30 AM
return the column reference number of a function result Mahendhra Excel Discussion (Misc queries) 2 May 16th 05 12:46 PM
column header changed from letter to number, how return to letter Ron Excel Discussion (Misc queries) 2 May 9th 05 08:34 PM
Defining a number in a cell by text then subtracting it by the tex Crowraine Excel Worksheet Functions 1 December 16th 04 08:49 AM


All times are GMT +1. The time now is 09:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"