Hey all, I am a sales rep and have to put all of my orders in a spreadsheet (item #, description, quantity, cost, and ext. cost). The question I have is, is there anyway to manually put all the item numbers, descriptions, and cost in once and then be able to pull up desc. and cost just by putting the item number in. I currently use apple spreadsheets (not sure the exact name) and excel in the office. Any help would be greatly appreciated

 

Okay so if I understand you correctly, you can use VLOOKUP

So let's say you have Worksheet 2 and it contains the following:

ITEM#, DESC, UNIT PRICE (Columns A-C)

Sheet 1 (Your order data) contains:

ITEM#, DESC, UNIT PRICE, REP, QTY, TOTAL COST (Columns A-F)


=VLOOKUP(A4,Sheet2!$A$2:$C$11,2,FALSE) Will get you the DESC

=VLOOKUP(A4,Sheet2!$A$2:$C$11,3,FALSE) Will get you the COST

So it takes your Unique identifier (item#) from Column A, matches it against the Sheet and the column_index_num to get the value from Sheet 2.

Hope this helps, and I trust you know enough about excel to manipulate the formula based on your actual spreadsheet data.

 

Note, I did this with Excel on a PC... Are you not using Office for Mac?

 

VLOOKUP FTW