My documents are a bit more complicated, but the answer to the below simplified version would help greatly. Please see picture example at link:
http://i30.photobucket.com/albums/c326/Jennifer__B/ExcelExample.jpg
Thank you in advance!
2007-03-08 11:33:46 · 3 answers · asked by Jelybe 1 in Computers & Internet ➔ Software
A simple vlookup formula will do. Google for it. Finding it is like finding buried treasure in Excel toolbox.
2007-03-08 19:49:44 · answer #1 · answered by unnga 6 · 0⤊ 0⤋
WOw! I did Advance classes in Excel, but this one doesnt quite click! Im sure i know how to do it, but i just cant figure out what really it is you want to do, I think its a Filter/Lookup formula....
Or maybe even better! the IF formual! it goes something like this
Cell B2 ..... =IF(A2=Smith, "Green", " ")
Cell B3 ..... =IF(A3=Cole, "Red", " ")
Ectt ectt....
Good luck!..
if did it wrong, im sure its still the IF formula you want to use!
2007-03-08 11:53:30 · answer #2 · answered by Anonymous · 0⤊ 0⤋
well, try checking out this website www.excelgoodies.com
they teach excel online. they do provide online help. why dont u try that site.
2007-03-09 03:53:33 · answer #3 · answered by sam e 2 · 0⤊ 0⤋