Thread
:
New user needs help
View Single Post
#
5
Posted to microsoft.public.excel.newusers
BB
external usenet poster
Posts: 39
New user needs help
Thank you Sandy Mann!!! It works a treat!
"Sandy Mann" wrote:
I can't see OssieMac's code either but unless I am reading you wrong you
don't need VBA.
In B2 enter:
=IF($A$2="","",VLOOKUP($A2,$A3:$E10000,COLUMNS($A$ 2:B2),FALSE))
and drag across to E2 using the fill handle.
If your data is wider than Column E then expand that range in the formula.
Now hen you enter a Product Code in A2 the other cells will automatucall
fill in with the other data.
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"BB" wrote in message
...
Hello
I have a spreadsheet of a rather large stocklist. I use this to check off
the price charged on the invoice when we receive the goods, against the
quoted buy price in the spreadsheet. Column A3 - A8000 (ish) contains a
product code; B3 = description; C3 = buy price; D3 = sell price; E3 =
Profit
margin, etc.
What I would like to do to make this job of checking the prices off more
efficient, is to type in the product code of the item i am checking in
say,
A2, and have the corresponding information appear. Is this possible???
Any help would be greatly appreciated. Thank you
Reply With Quote
BB
View Public Profile
Find all posts by BB