VLOOKUP trouble .. HELP!
Hi I am a novice in excel. Sorry. I have tried the help and this forum but
just am not getting Vllokup functions.
I have a spreadsheet with the following values (example)
Column A
Allocated
Not Allocated
Restricted
Quarantined
I want to be able to do similar to an if statement where I can lookup the
value in colum A and if "Allocated" put the value "Held" in column B but if
"Not Allocated" put the value "Spare" in Column B.
I hope this makes sense. Your help is appriated.
Dylan Moran - Melbourne Australia
|