I think this would be conditional formatting

  • Thread starter Thread starter Kile
  • Start date Start date
K

Kile

I have made a spreadsheet that does estimates for the
company i work for. I currently use two sheets for this
program, now i want to use a third sheet. the third sheet
would be to list certain inventory and the price per
unit. I want to know if i can type in a specific item in
sheet1 in one cell and have the price of that item listed
on sheet3 into another cell on sheet1. If i didn't
explain myself well enough please let me know and i will
try again. If you know the answer to my question, please
help me. Thank you very much.
 
Assume your specific items are listed in Sheet3, Column A and the
prices in Sheet3, Column C.

Also assume that you'll make your sheet1 entry in B1. Then in C1,
enter


C1: =VLOOKUP(B1, Sheet3!A:C, 3, FALSE)
 
Back
Top